Is This Possible?????

[zteam777]

I know how to create drop down lists in a cell. My question is this:

Is it possible to create multiple drop down lists on a single cell say A2 and then on cell A1,based on what is selected from that list, have A2 display one of the multiple drop downs created?

Example:

A1: (one drop down list)
List contains:
Ford
Toyota
Nissan

A23 separate lists created)
List 1:
Mustang
F-150
Tundra

List 2:
Avalon
Celica
Tercel

List 3:
Sentra
300X

Now when A1 selects Toyota, List 2 will appear in A2

I may be reaching here guys but I just wanted to know.

Thanks

 

[Jonmo1]

Yes it's doable, but will take some effort and organization on your part...

This should help..

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