I have a workbook with two worksheets in the attached - one is called "With ID", the other is "Without ID."
I need to pull in column A id's from worksheet 1 into column A on worksheet 2 by searching for last name then first name. The names in worksheet 1 are in different formats and sometimes have up to 30 names in one cell in columns c and d.
However, in worksheet 2, (without id), each name is in its cell.
I was trying Index/Match feature but can't get it to work. Can somebody look at the attached and tell me how to do it.
It would be greatly appreciated.
A~
Bookmarks