Previous Topic Next Topic

Matching 2 sheets

Solved/Closed
ToEKnee213 Posts 1 Registration date Wednesday 16 December 2020 Status Member Last seen 16 December 2020 - 16 Dec 2020 à 21:09
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 24 Dec 2020 à 11:46
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
24 Dec 2020 à 11:46
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