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.