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______

_____________________________

1___X_______C1_______20_________

2___________ B1 _______15________

3___L________D1________100______

4 ___________E1________ 35_______

5___R________F1________17______

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.

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

___A_______ B_______ C_______

__prod_____ loc______ qty______

_____________________________

1___X_______C1_______20_________

2___________ B1 _______15________

3___L________D1________100______

4 ___________E1________ 35_______

5___R________F1________17______

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: