series of "list" options

[Stan]

somebody help!!
i need to creat series of drop-down menu with series of data.
cell A : cell will have 12 choices (from column X : 12 items)
cell B : per each choice in cell A, a dropdown menu with 10 choices each
(from colum Y : 10 items per 12 choices from cell A=120 items)
column C : per each choice in cell B, an additional dropdown menu with 10
choice each (from column Z : 10 items per 10 choice from cell B=100 items)

because "list" option from "data validation" function won't allow "if"
function, i can't come up with the right function.

please help.

 

[ShaneDevenshire]

Hi,

You should range name each of your lists with the name that appears in the
calling list. Then you should use INDIRECT(name) in the Data, Validation,
List, Source box.

Simple example:
Cell A1 contains a DV list of two names from column X suppose those two
choices are US and Canada, create two lists, one for US one for Canada. To
make it simple the Canada list will contain two items Toronto and Quebec, say
in cell D12 and US with New York and San Francisco in E1:E2. Name the
first range Canada and the second range US. In another cell where you want
to display one of the two list choose Data, Validation, List and in the
Source box enter
=INDIRECT(A1)

When you choose an item from the list in cell A1, Canada or the US, the list
in this second cell will reflect only items from either the Canada or US list.

You range name a set of cells by highlighting them and typing the name into
the Name Box on the left hand side of the Formula Bar.


If this helps, please click the Yes button.

 

[Stan]

Shane,thanks.

One Q. is there a rule for naming the subgroup, such as "," "space", or
limits on characters? I followed ur example and it worked. unfortunately,
some of my selections have 50 characters.

Stan

 

[Sheeloo]

Can not contain Spaces, "," etc...
50 characters will be Ok...