Max, that works except what I'm trying to do is change the number in A1 to
the resulting text in the same cell. In otherwords, if A1=400, change the
400 in A1 to "James" So if I type 400 in A1 it will automatically change it
to "James" as soon as I move to the next cell.
--
Carolan


"Max" wrote:

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.