Let's assume Sheet2 is not used (bit it could be Sheet201 !)
Make a table like this
Code Name
1 Accounting - Payables
2 Accounting - Receivables
3 Accounting - Debt Collecting
.....
123 Publicity

For our demo we will say the table uses the range A2:B25 (labels in row 1)

Back on the 'real' worksheet. The three-digit codes are in say column C
starting in row 2
In the cell where you need the department name (D2, maybe) enter
=VLOOKUP(C2,Sheet2!A2:B25,2,FALSE)
Copy this down the column
Come back if you have further questions - post them as a reply to this
message
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Still learning@work" wrote in
message ...
I'm working in an employee spreadsheet. In this worksheet, the department
number is either a 1, 2, or 3 digit number. In order to print reports, I
would like to be able to have the department name printed out.

Is there a way to write a formula OR to tie the information in that cell
to
the full name in another spreadsheet or workbook? Example: Dept. "1" =
"Accounting - Payables". I have 25 departments and 200 employees and I
don't
want to cut and paste.

I've struggled with the "IF" formula to no avail. So help on this would
be
greatly appreciated.