matching 2 columns
I have 2 excel spreadsheets. One has all of our employee information and the
other one just has employee id. The worksheet with employee id needs to be updated with gender. How can I do this without looking up each 1 individually? I am looking for a way to automate this process. Thank you. |
matching 2 columns
Ann
Check out the vlookup function in Excel help. This should be all you need to link the two spreadsheets on employeeID. Regards Rowan "ann" wrote: I have 2 excel spreadsheets. One has all of our employee information and the other one just has employee id. The worksheet with employee id needs to be updated with gender. How can I do this without looking up each 1 individually? I am looking for a way to automate this process. Thank you. |
All times are GMT +1. The time now is 02:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com