MrExcel Publishing
Your One Stop for Excel Tips & Solutions

LookUp Help.


Posted by Mike on January 30, 2002 7:45 AM

In column "S" I have the following formula:
Median(V17:AT17) for my Median Cost (from 3 choices).

From Coulmn Header V13:AT13 runs my Suppliers.

From V17:AT17 runs my quoted "costs" (of which there
are only 3 choices so my Median pulls the middle quoted price).

My formula in U17 reads:
(LOOKUP(S17,V17:AT17,V$13:AT$13).
I read this as What ever shows up in S17, go to the choice in row 13 above and pull the Supplier Name.

The cost in S17 is $3.43 (from Y17).
X13 (Supplier name is "Daria",
Y13 (Supplier name is "Nordt",
Z13 (Supplier name is "Link".

The result from the LOOKUP Fx should be Nordt,
yet it's pulling Daria.

It works for MIN & MAX but not MEDIAN.

Any reason why?


Posted by Larry on January 30, 2002 3:16 PM

**** When using the LOOKUP function the data must be in ASCENDING order, unlike the VLOOKUP(Lookup value, range, column,FALSE) function