Lookup returning #n/a

I

irvine79

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to correct a #N/A in vlookup 1
VLOOKUP returning #N/A result 2
Summing data based on a seperate column 4
Help with these formulas 7
Excel Lookup Formula 4
#N/A error with VLOOKUP function 3
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
VLOOKUP returning #N/A ?? 3

Top