Look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jacki" wrote in message
...
What is the best way to be able to enter a number into a cell and it
returns
the name that corresponds with that number in the cell to the right of it.
The numbers and names to view from would be on a master/seperate
worksheet.

Thanks so much for your help.