In excel this works but not is sheets can anyone confirm or suggest another method.

=VLOOKUP("*"&B1&"*",A:A,1,FALSE)