=IF(OR(NOT(ISERROR(SEARCH(B:B,A2)))),A2,"")
=VLOOKUP("*"&B1&"*",A:C,3,0)
Copy down.
If data starts on row 2, enter in C2 and confirm with CTRL-SHIFT-ENTER:
Code:=IF(OR(NOT(ISERROR(SEARCH(B:B,A2)))),A2,"")
And copy down.
<tbody> </tbody> |
{=IF(OR(NOT(ISERROR(SEARCH(B:B,A2)))),A2,"")}
Without CTRL-SHIFT-ENTER:
=IFERROR(INDEX(A:A,MATCH("*"&B1&"*",A:A,0)),"")
Have you changed anything in your Windows Regional Settings?