I don't want to type DOE in every cell, otherwise I would just search for
everyone and highlight them manually. I though there should be a search
function which automatically search all the terms in one cell and compare it
to the array in another coulmn.

"Alan" wrote:

Try the FIND or SEARCH functions, FIND is case sensitive, SEARCH is not. eg
=IF(ISERROR(FIND("Doe",A1)),"No","Yes") will return 'Yes' for 'Doe', but not
'doe'
=IF(ISERROR(SEARCH("Doe",A1)),"No","Yes") will return 'Yes' for 'Doe' or
'doe'
Both will return 'No' if there is no match.
Regards,
Alan.
"Trumpet" wrote in message
...
Hello every, I have a question and would really appreciate if someone
could
reply me ASAP.
I have two columns in excel
Coulmn A contains 500 cells for example
Jane Doe, SOme Last name, Hellp there,
Coulmn B contain 70 cells only with example
Doe J, Lastname S, There H
I only have 70 matches, but i don't know how to match those 70 cells to
the
500 cells. I am looking for a partial match to check in cell A2 (for
exmple)
if there is DOE in cell B2 and return the value Yes in cell C2

May you please help