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