F
FARAZ QURESHI
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.
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.