Reference Lookup

A

alec

Excuse the easy question, i am a complete beginner and need some assitance at
my workplace.

I have a two digit code that refers to a department in my office numbers 11
- 99
I want to be able to use that code in a spreadsheet and have the cell next
to it return the name of that department.
I have set up the first worksheet as a "database" in that I have a list of
the numbers, and a list of the departments in each row.

How would i go about this?
 
A

Alan

Try VLOOKUP in Help, something like
=VLOOKUP(Your Office Number,Your Database Cell References,2,FALSE)
Regards,
 
Top