Return employee name when the employee's number is entered

In my workbook I have a sheet that contains two columns. One has employee
name and the second has an employee number. Now, on another sheet I want to
enter an employee number and in the next cell have it return the employee's
name. How can I do this?

If the second is to the right you can use a simple VLOOKUP. See in HELP
index.
If on the left you would need to use MATCH to find the row and then
incorporate into an INDEX function. Again, the HELP index is your friend.

--
Don Guillett
SalesAid Software
[email protected]
"Mike" <[email protected]> wrote in message
news:[email protected]...
> In my workbook I have a sheet that contains two columns. One has employee
> name and the second has an employee number. Now, on another sheet I want
to
> enter an employee number and in the next cell have it return the
employee's
> name. How can I do this?