Maybe something like this

Assume numbers in Sheet1, in A1 down
In Sheet2, place in A1:
=IF(Sheet1!A1="","",VLOOKUP(Sheet1!A1,{400,"James" ;401,"John";402,"Kevin"},2,0))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Carolan" wrote:
I'd rather do a formula if possible on a different sheet as I will have
several name. For example, 400 = James, 401 - John, 402 = Kevin. So there
could be all three numbers in a column.