Conecting Drop down lists

  • Thread starter Thread starter C Vi
  • Start date Start date
C

C Vi

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?
 
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
 
What do the '2,False' represent?

Bernie Deitrick said:
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
Click to expand...
 
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
 
Back
Top