For one way to use relational tables and create a drop-down validation list
based on selection(s) in other drop-downs, see
Cascading queries
http://www.tushar-mehta.com/excel/ne...wns/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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!