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