Previous Topic Next Topic

Matching 2 sheets

Solved/Closed
ToEKnee213 Posts 1 Registration date Wednesday December 16, 2020 Status Member Last seen December 16, 2020 - Dec 16, 2020 at 09:09 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 24, 2020 at 11:46 AM
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!
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 24, 2020 at 11:46 AM
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