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.

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.