Hi Bill - Not sure that I quite understand it.

I have 2 employees numbers in cells a5 and a6 and the names in cells b5 and
b6. I'd like to type an employee number in a13 and for it to return the
relevant name. What would be the formula? Hope this makes sense.

"Bill Kuunders" wrote in message
...
You need to have a table of two columns (or more for other info) where the
first column is the
emplyee number and the second is the name.

=vlookup(A5,F3:G60,2,false) will give you
the name of the empl# in A5 from the table.
2 stands for the second column of that table.

--
Greetings from New Zealand
Bill K

"Dave S" wrote in message
...
Is there some way that when I enter an employees number in to a cell it
will return the name?

Thanks for your help - Dave