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.

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 D1:D2 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.
--
Thanks,
Shane Devenshire


"Stan" wrote:

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.

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

"ShaneDevenshire" wrote:

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 D1:D2 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.
--
Thanks,
Shane Devenshire


"Stan" wrote:

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.

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

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Stan" wrote:

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

"ShaneDevenshire" wrote:

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 D1:D2 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.
--
Thanks,
Shane Devenshire


"Stan" wrote:

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.