matching 2 columns

[ann]

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.

[Rowan]

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.