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!
|