Drop Down Lists

[Guest]

I have a drop down list in one cell with answers a, b, and c. I would like
to have a drop down box in the cell next to it that gives choices based on
the choice made in drop down list 1. For example, if I click on (a) in the
first drop down list, I would like tha choices 1, 2, or 3 in the 2nd drop
down list. If I click on (b) in the first drop down list, I would like tha
choices 4, 5, or 6 in the 2nd drop down list. Is this possible in Excel
2007?

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Guest]

Hi,

Start by creating the 3 list you mention somewhere out of sight in your
workbook, next name those 3 list something like... Alist, Blist and Clist,
since C is reserved for column selection you cannot use "C" for a named
range. Now select your cell you want your second drop down list in and go to
Data/Validation, select "list" from the drop down menu and type
=INDIRECT(A1&"list"), A1 being the original drop down list "A,B,C"....adjust
to suit!

HTH
Jean-Guy