Compare range data to another column data

Originally Posted by canapone

Hi again,

if you need true or false as outputs

Formula:

=IF(A1=""," ",ISNUMBER(MATCH(1,INDEX(SEARCH("*"&$C$1:$C$121&"*",A1),),0)))

Hope it helps

Yes this is perfect. Thanks