Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
can you help please?
i have the following cell C3 = data validation from a fixed range (5 drop down options) cell C6 = data validation drop down - the choice in C3 determines the list in drop down in cell C6 (i.e. 1 of 5 different list will appear in the drop down) the 5 lists which are determined by cell C3 are all dynamic ranges named, lets call them apple, pear,orange, grape and plum. these 5 named ranges are the same names as the drop down options in cell C3. For some reason it doesn't work using indirect because of the formula, is there a way to make this work? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation and Dynamic Ranges | Excel Discussion (Misc queries) | |||
Dynamic Data Validation | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |