Results 1 to 4 of 4

Thread: help with a complicated VLOOKUP

  1. #1

    Unhappy help with a complicated VLOOKUP

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Gurus

    I have a question about VLOOKUP formula and i really hope that you could help me with this.

    ___A_______ B_______ C_______

    __prod_____ loc______ qty______
    2___________ B1 _______15________
    4 ___________E1________ 35_______
    6 ___________G1 ________97______

    What I need is a VLOOKUP formula where my LOOKUP value is "prod" and it should return the location of the product.(result shown in cell D1) i got until this part but the trick is that since 1 product is in more than 1 location (it could be more than 2 locations) , i need the VLOOKUP to return the location with the lowest qty for that product, qty must be >0,

    Any help with this problem wil be greatly appreciated.
    Last edited by gullit; 2011-08-12 at 04:08 AM.

  2. #2
    Try this array formula


  3. #3
    Thank you Bob for your Help!
    I tried the formula that you posted, it worked but i needed the result to be shown in a different cell. Looking around a found a formula that works just like i wanted. I have posted the formula below for anybody that is looking for somenthing similar!


    Thanks a whole bunch for your help! this site rocks! I'll be back with more!

  4. #4
    Why didn't you put mine, which is more efficient, in that cell?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts