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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"thunderbunny" wrote in message
...
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???