You can try using a string of IF functions to check the job code and display
the appropriate job name. Here's an example:

=IF(A1="JOB1","Job Code 1",IF(A1="JOB2","Job Code 2",IF(A1="JOB3","Job Code
3","")))

This just checks to see what A1 is and displays some corresponding name in
A2. It will also leave A2 blank if A1 is blank.

It can get a little more complicated if you are using a different convention
for your job codes, though. If say all job codes for a particular vendor or
client begin with the same 2 characters but the rest of the code is
numerically sequential.

Example: AP001, AP002 are both job codes of Atlas Printing. FP001, FP003
are both job codes for Frank's Pizza.

If this is the case just change the logic part of the if statement to check
the first two characters of the job code with the LEFT function.

=IF(LEFT(A1,2)="AP","Atlas Printing",IF(LEFT(A1,2)="FP","Frank's
Pizza",IF(LEFT(A1,2)=...

I hope this helps.

"excelrookie" wrote:

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?