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!

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!

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!