Similar to what Tom described, there's a sample file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0037 - Dependent Lists Country City'

Shan wrote:
I will try to keep this as brief as possible.

I have a spreadsheet that is used for quoting projects. For the 'Company
Name' (A13), I have created a drop-down menu (this references a validation
list in another worksheet in the same workbook). I have used the following
formula which fills in nicely the street address (A14):

=IF(A13="","",INDEX(Address1,MATCH(A13,Company,0), ))

...and the city, state zip (A15):

=IF(A13="","",INDEX(Address2,MATCH(A13,Company,0), ))

I have also set this up to fill in the contact name and email. In the
instance where there are several different people requesting quotes at 1
company; I would like to create a drop-down list for the contact name that
will let me choose which contact to send the quote to, once the company has
been selected. Is this possible and if so, how would I go about setting this
up?

So for example, if I chose ABC Company and the address fills in, I would
like to go to the contact name and select whether I want to send this quote
to either Bob Smith or Dave Nelson and have their email address fill in as
well in the appropriate cell.

Thanks!



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html