roxie

Somewhere out of the way build yourself a table that looks like this

1 Job 1
2 Job 2
3 Job 3
Etc

Then if you enter a job code in (say) a1in the adjacent cell have this
formula
=VLOOKUP(A1,M1:N3,2,FALSE)

In my case the (Shortened) table is in M1 - N3

Mike

"Roxie" wrote:

What is the easiest way to set up a spreadsheet where I can enter a code (Job
code) in one cell and have the description come up in another cell?

I have over 20 job codes and the IF formula will only go to 7.

Thank you.

--
Roxie