Something like:

=ISNUMBER(MATCH("*"&X1&"*",A:A,0))