I have the range A1:A125000 with names of clients. In range C1:C15 there are
some of names (Partial) that I have to find in the A1:A125000. What sort of
formula should I place in B1:B125000 to return an "X" if the corresponding
cell in a consists any of the word in C1:C15?

Something like:

B1=If(isnumber(find(???,A1)),"X","")

to be copied down?

The problem is that C1:C15 do not contain names in full but in parts. Like I
want a cell entry Johnson be highlighted if John exists in C1:C15.

Seeking your expert advice.

Thanx in advance.

--

Best Regards,
FARAZ A. QURESHI