Thread: With F1 value, look at A, if match or partial match return B
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard L. Howard is offline
external usenet poster
  
Posts: 852
Default With F1 value, look at A, if match or partial match return B
in D2 try:
=IFERROR(VLOOKUP("*"&$F$1&"*",A2:B2,2,0),"")
or
=IF(SUMPRODUCT(ISNUMBER(FIND($F$1,A2))*1)=1,B2,"")


Regards
Claus B.


Thanks Claus.

The SUMPRODUCT formula works best. It returns B correctly in all cases I tested where the others return "" if the match is the leading characters in A.

Appreciate it.

Howard

Not sure why the others return ""
Reply With QuoteReply With Quote