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.
How would be the best way to combine these to reflect all the info on sheet 1?