Hi there,
I have attached the worksheet.
in "look from" worksheet, you see a list of names. Same thing on the "to update" worksheet. The only difference is that names from these two columns are NOT exactly the same. (there is always a space after the comma in the "look from" worksheet)
What I would like to:
look up each name found in "look from" on the "to update" sheet. If a matching name is found in "to update", then in column A of the corresponding name of worksheet "to update", I need to put in a "yes".
Is the match() sufficient here? or is some kind of macro is needed?
thank you any assistance.
Bookmarks