Hi,

I'm hoping to amend the formula so I can search for any number found in column b, i.e 12345, appears in any part of a cell in column a, i.e acc12345.

I can only get this to work if the values are on the same row, not anywhere in either column.

=IF(ISNUMBER(SEARCH("*"&K:K&"*",$A$2:$A$33)),K:K," No")

Is what I am currently using, but this will only return a result if the value in "K" appears on the same row in "A".