Matching 2 sheets

Solved
Report
Posts
1
Registration date
Wednesday December 16, 2020
Status
Member
Last seen
December 16, 2020
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 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
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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