Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm trying to determine how a series of dropdown lists were creat. | Excel Discussion (Misc queries) | |||
Dependent dropdown lists | Excel Discussion (Misc queries) | |||
How to refresh dropdown lists in PivotTables? | Excel Discussion (Misc queries) | |||
Dropdown lists | Excel Discussion (Misc queries) |