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


--
Natasha78
------------------------------------------------------------------------
Natasha78's Profile: http://www.excelforum.com/member.php...o&userid=26495
View this thread: http://www.excelforum.com/showthread...hreadid=397607

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 this
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 using


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=397607

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)

--
Greetings from New Zealand
Bill K

"Natasha78" wrote
in message ...

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


--
Natasha78
------------------------------------------------------------------------
Natasha78's Profile:
http://www.excelforum.com/member.php...o&userid=26495
View this thread: http://www.excelforum.com/showthread...hreadid=397607