Hi- I was searching the board and see a lot of useful information, however it doesn't seem to answer my question.
I have a master list of employee names and ID numbers which is about 1800 rows -the data is in Columns A&B. I also have a smaller list of employees without ID numbers - This list is in Column C- The employees in the smaller list should be included in the 1800. How do I compare C to A&B and then paste the ID numbers of Column C Employees in Column D?
I have a master list of employee names and ID numbers which is about 1800 rows -the data is in Columns A&B. I also have a smaller list of employees without ID numbers - This list is in Column C- The employees in the smaller list should be included in the 1800. How do I compare C to A&B and then paste the ID numbers of Column C Employees in Column D?