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