choice from a drop down list returns a result to a different cell

[thunderbunny]

in the drop-down box when you make a selection such as "repair" "customer
service" or "rental" I want it to return contact info that would be different
for each possible choice but to display in the adjacent cell. Seems that
that this should be easier than it is turning out to be. Any suggestions???

 

[Jon Peltier]

Use a lookup formula in the cell with contact information, so it looks up
the appropriate value from a table based on the selection in the dropdown.

- Jon

 

[Shane Devenshire]

Here's a little more detail:

If the drop down list is a data validation list and it is in cell A1 then in
B1 enter the formula
=VLOOKUP(A1,ContactTable,2,False)

Which means you need to set up a range with the possible choices in the
first column, the contact info in the second... columns. I have named that
range in my example "ContactTable". The info I want back is in the second
column, which is what the 2 tells Excel. And the False means I want an
exact match.

Cheers,
Shane Devenshire
Microsoft Excel MVP