Dependent dropdown lists
 

I've found a simple method online for creating a secondary dropdown
list based on the selection from a primary list, but it requires use of
two worksheets. 1) Why is that? 2) Is there a another simple way
that can be done all in 1 sheet?

3) Finally, is there a way to manually type in the data validation box
what you want, i.e.
=if(item_from_primary_list
then "secondary_list_item_#1", "secondary_list_item_#2...) ??
Thanks!

Dependent dropdown lists
 

Hi


"Matt" wrote in message
ups.com...
I've found a simple method online for creating a secondary dropdown
list based on the selection from a primary list, but it requires use of
two worksheets. 1) Why is that? 2) Is there a another simple way
that can be done all in 1 sheet?

Of course is.

On a sheet, create a table with primary selection values as column headings,
and enter secondary selection values into apropriate columns.
PSelection1 PSelection2 PSelection3 ...
sel1_1 sel2_1 sel3_1 ...
sel1_2 sel2_2 sel3_2 ...
..... ... ... ...

Now define header row as one named range ( when the number primary
selections isn't fixed, then it must be dynamic).
Then define another dynamic named range, which returns data from proper
column, depending on primary selection value.


Arvi Laanemets



3) Finally, is there a way to manually type in the data validation box
what you want, i.e.
=if(item_from_primary_list
then "secondary_list_item_#1", "secondary_list_item_#2...) ??

Enter secondary list values into cell ranges on some (hidden) sheet. Then
validation range will be
=IF(primary1,Reference1,IF(primary2,Reference2,... ))



Arvi Laanemets