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

Summing data based on a seperate column 3
VLOOKUP returning #N/A result 2
Excel Lookup Formula 4
Help with these formulas 7
Interval accumulation and resets 1
How not to show "#VALUE" 7
#N/A error with VLOOKUP function 3
Question on a Formula 6

Top