If you set up a database, say in Sheet 2 with your job names and numbers,
say Col A and B, then create a range name for this range - eg JobNames.

Now in A2 enter the following:
=IF(A1="","",VLOOKUP(A1,Jobnames,2,FALSE). All on one line!

"excelrookie" wrote in message
...
Hi!
I'm sure that this will be a 'given' to most of you. I enter data into
time
sheets daily
where i have to enter the job code as well as the job name ie: cell A1,
the
job code in A2, I will type the job name . Is there a way to set this up
so
that when i type the job code in A1, the job name will display in cell A2?