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?

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?

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?

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?

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?

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?