Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conecting Drop down lists
I am making a worksheet template for my office and below the signature line I
have a drop down list made through the 'Data Verification' method listing all The sales people, in the cell below that is the name od my company but below that i want to have the selected persons phone number come up below the company name, how can i do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conecting Drop down lists
Use a VLOOKUP formula on a table of names and numbers, like
=VLOOKUP(D25,$E55:$F100,2,False) where D25 has the name, and $E55:$F100 has the table. HTH, Bernie MS Excel MVP "C Vi" <C wrote in message ... I am making a worksheet template for my office and below the signature line I have a drop down list made through the 'Data Verification' method listing all The sales people, in the cell below that is the name od my company but below that i want to have the selected persons phone number come up below the company name, how can i do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conecting Drop down lists
What if the list of numbers is on a different sheet in the same workbook.
"Bernie Deitrick" wrote: Use a VLOOKUP formula on a table of names and numbers, like =VLOOKUP(D25,$E55:$F100,2,False) where D25 has the name, and $E55:$F100 has the table. HTH, Bernie MS Excel MVP "C Vi" <C wrote in message ... I am making a worksheet template for my office and below the signature line I have a drop down list made through the 'Data Verification' method listing all The sales people, in the cell below that is the name od my company but below that i want to have the selected persons phone number come up below the company name, how can i do this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conecting Drop down lists
What do the '2,False' represent?
"Bernie Deitrick" wrote: Use a VLOOKUP formula on a table of names and numbers, like =VLOOKUP(D25,$E55:$F100,2,False) where D25 has the name, and $E55:$F100 has the table. HTH, Bernie MS Excel MVP "C Vi" <C wrote in message ... I am making a worksheet template for my office and below the signature line I have a drop down list made through the 'Data Verification' method listing all The sales people, in the cell below that is the name od my company but below that i want to have the selected persons phone number come up below the company name, how can i do this? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conecting Drop down lists
If your list is on another sheet:
=VLOOKUP(D25,'Sheet with names'!A1:B100,2,FALSE) The 2 means "match the value in the first column, and return the value from the second column." The False means that the list isn't sorted, and VLOOKUP should look for an exact match. To ensure that you have an exact match, your data validation list should use the same list - you will need to name the range A1:A100 on 'Sheet with names', say "ValidNames", and use =ValidNames as the list source. HTH, Bernie MS Excel MVP "C Vi" wrote in message ... What do the '2,False' represent? "Bernie Deitrick" wrote: Use a VLOOKUP formula on a table of names and numbers, like =VLOOKUP(D25,$E55:$F100,2,False) where D25 has the name, and $E55:$F100 has the table. HTH, Bernie MS Excel MVP "C Vi" <C wrote in message ... I am making a worksheet template for my office and below the signature line I have a drop down list made through the 'Data Verification' method listing all The sales people, in the cell below that is the name od my company but below that i want to have the selected persons phone number come up below the company name, how can i do this? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conecting Drop down lists
VLOOKUP is a standard Excel function. Its syntax is shown in Excel help.
-- David Biddulph "C Vi" wrote in message ... What do the '2,False' represent? "Bernie Deitrick" wrote: Use a VLOOKUP formula on a table of names and numbers, like =VLOOKUP(D25,$E55:$F100,2,False) where D25 has the name, and $E55:$F100 has the table. HTH, Bernie MS Excel MVP "C Vi" <C wrote in message ... I am making a worksheet template for my office and below the signature line I have a drop down list made through the 'Data Verification' method listing all The sales people, in the cell below that is the name od my company but below that i want to have the selected persons phone number come up below the company name, how can i do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
drop down lists | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Conecting/updating cells on two w/s | Excel Discussion (Misc queries) |