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.