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