If this condition meet, then this text

[Still learning@work]

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.

 

[Bernard Liengme]

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