Thread: Help with Excel lookup function please
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
  
Posts: 199
Default Help with Excel lookup function please
"Ragdyer" wrote in message
...
Try this:

=IF(SUM(--(A3:F20=A22)),INDEX(A2:F2,
MAX((A3:F20=A22)*(COLUMN(A:F)))),"No Match")

Still an *array* formula.

Many thanks,

V

Reply With QuoteReply With Quote