Hi, I'm new here, I did excel in my first year of college and I did learn a lot, but however I have forgotten most of it since I haven't used it since.
Is there a formula I can use that can Match the employee ID on the first worksheet with the employee ID on the 2nd sheet and then return the employees first and last name to the 1st worksheet? I have tried MATCH, INDEX and VLOOKUP and either I'm not using them right or there are errors.
There are 2543 rows of employee ID, and 224 Names.
Any help will be greatly appreciated.
Is there a formula I can use that can Match the employee ID on the first worksheet with the employee ID on the 2nd sheet and then return the employees first and last name to the 1st worksheet? I have tried MATCH, INDEX and VLOOKUP and either I'm not using them right or there are errors.
There are 2543 rows of employee ID, and 224 Names.
Any help will be greatly appreciated.