Matching 2 sheets

Report
Posts
1
Registration date
Wednesday December 16, 2020
Status
Member
Last seen
December 16, 2020
-
Posts
2717
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 1, 2021
-
I'm driving myself mad trying to figure this out.
I have 2 sheets. I need to match First & Last name on both sheets. If the name matches, then I need an output of another cell in the second sheet.

For example:
Sheet 1 has First, Middle, Last
Sheet 2 has First, Last, First Last Userid

if there is a match, I need the First Last Userid to populate Sheet 1 in a separate column.

Help!

1 reply

Posts
2717
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 1, 2021
458
Hi ToEKnee,

Make 1 value out of the First and Last name cells. Like =A1 & C1 for sheet1. You can hide this column.

Now you can use VLOOKUP to find the First Last Userid value. Make sure that the concatenated column is to the left.

Best regards,
Trowa
1
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!