Reference Lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try VLOOKUP in Help, something like
=VLOOKUP(Your Office Number,Your Database Cell References,2,FALSE)
Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup Worksheet 4
Access Making a memo in Access 0
Excel Wildcard in Excel array formula 0
Lookup related question 1
Need help with CountIF function 2
SUMIF function not calculating from closed worksheet 1
Two Criteria COUNTIF 7
Possible Lookup 11

Back
Top