View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
irvine79 irvine79 is offline
external usenet poster
 
Posts: 21
Default 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!