| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
dependent combo box list, with indirect reference
I would like to create a dependent combo box.
I have a cell linked to anothe combo box, say C1. I have one list in D1:D4, another list in E1:E3. In C2, I have value "D1:D4", in C3 I have "E1:E3". For the input range for the combox, I tried "=INDIRECT(IF(C1=1,C2,C3))", but only got an empty list. Is this 'illegal'? Thanks, Iyue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo box list depends on value | Excel Discussion (Misc queries) | |||
| Drop down list or combo box help needed | Excel Discussion (Misc queries) | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Dependent List Query | Excel Worksheet Functions | |||
Threaded Mode
