I need help

N

Natasha78

I work at a hospital and I'm trying to make it so that if I enter
floor (i.e. 2C) in one field, the callback number (i.e. 66289) and th
floor name (i.e. Surgery) fill in automatically. Is there a way t
program these into Excel so it will do that? It would save me a lot o
work
 
C

Cutter

Build a table somewhere on your sheet (or another sheet)
In the first column of the table put your floor numbers
in second column the callback number
in third column the floor name

Name the range holding your table something like Directory

In the cell to the right of where you type the floor number put thi
formula:
=VLOOKUP(A1,Directory,2,0) to get callback number
and in next cell to right type this formula
=VLOOKUP(A1,Directory,3,0) to get floor name

Note: I used A1 as the cell you would use to input the floor number
change it in each formula to the actual cell you are usin
 
B

Bill Kuunders

You would need to set up a small table (in say R1 to S10) with
in the first column the floor levels and in the next column(s)
the call back and name (they can be in one cell)
Enter in for instance F3 the level 2C
enter in G3 =vlookup(F3,R1:S10,2)

this translated into english
lookup the value of F3 in the first column of R1:S10 and give me the
corresponding value in the second column of that table.

If you want to seperate the call back and name into two columns then
you will need to enter in say H3 =vlookup(F3,R1:T10,3)
 
Top