Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup returning #n/a
Looking for formula that returns value from column A from the same row as min
value in column D. Keeps returning #n/a. here is formula I am using... =LOOKUP(MIN(D33:D42),D33:D42,$A$33:$A$42) Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup value in table without returning #N/A | Excel Discussion (Misc queries) | |||
Lookup returning incorrect value | Excel Discussion (Misc queries) | |||
Lookup is not returning the right value. | Excel Worksheet Functions | |||
Lookup returning one more than expected | Excel Worksheet Functions | |||
lookup returning several cells | Excel Discussion (Misc queries) |