Forum Discussion
Solved
Best way to pull ID numbers to match Names
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 ...
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.
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.