Best way to pull ID numbers to match Names

[kittenmeants]

Hello!

I have two sheets, both have employee ID numbers. One sheet has their corresponding name, and the second sheet has their corresponding phone number.

The issue I am running into is one data pull gives me 200+ results (sheet 1), and the second gives me a larger criteria (400+ results). The second sheet gives me extra non-exempt employees but I can't exactly just do a quick filter to remove, I thought the best way would be to match the ID numbers.

Sheet 1:

Employee ID	Name	Contact Info
1100	Jane Smith

Sheet 2:

Employee ID	Contact Info
1100	555-2345

How would be the best way to combine these to reflect all the info on sheet 1? 

Thank you!

[#2 · Accepted solution]

@kittenmeants 

You can use XLOOKUP or VLOOKUP on Sheet1 to return the phone number from Sheet2:

=XLOOKUP(A2, Sheet2!A:A, Sheet2!B:B. "")

If you want to add the IDs from Sheet2 that don't occur on Sheet1, you can use VSTACK and UNIQUE to combine the two lists on another sheet.