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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup returning #n/a
for LOOKUP D33:D42 should be in sorted order..
Instead try with MATCH and INDEX =INDEX(A33:A42,MATCH(MIN(D33:D42),D33:D42,0)) If this post helps click Yes --------------- Jacob Skaria "irvine79" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup returning #n/a
Worked perfect. Thanks, you're the man!
"irvine79" wrote: 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! |
Reply |
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) |