Dear Excel pros, I need some help please!
I have two Excel Spreadsheets.
Spreadsheet 1 contains list of username like the following in one column:
Employee Names
Burris, Jack
Cortez, Eric
Smith, Mary
Brand, John
Boamah, Nana Yaa
Spreadsheet 2 contains list of First Names and Last Names in separate columns:
First Name Last Name
Jack Burris
John Wang
Ed Cool
Mary Smith
Jack Casey
Boamah Nana Yaa
I want to have spreadsheet 2 to look up spreadsheet 1 and put "Match" in 3rd column next to the names that matched (Both Firstname and Lastname appear in sheet 1). For example:
First Name Last Name
Jack Burris Match
John Wang
Ed Cool
Mary Smith Match
Jack Casey
Boamah Nana Yaa Match
Please advise. Thanks.
Open in new window
apply this by drop it down to following rows.
pls note for last entry:
Boamah Nana Yaa
will not be matched as the Last Name and FirstName is in reverse order.