I need help
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.
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
Last edited by Cutter; 08-21-2005 at 04:39 PM.
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks