Sure can. Just click over to the other sheet and select your cell references
from there (like you would if it was in the same sheet).

"Roxie" wrote:

Now, I have another question:

Can I put the table on another sheet? If so, how?

Ok, so it was 2 questions.

Thank you.
--
Roxie


"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