Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation with multiple table selection
Hi,
I'm trying to have a dropdown list look at another dropdown list & reference a particular named range based on the 1st dropdown's current selection. The actual amount of selections in dropdown 1 is 3, with 3 different named ranges to reference. I thought I could get away with the multiple options by using a series of CONCATENATE/IF statements, but it seems like I'm doing something wrong. If possible, I'd like to use this style, as I believe it will be useful for future dropdown lists I'll want to add later in my workbook. Here is the formula Iam trying to enter into Data Validation/Source: =CONCATENATE(IF(F4="Analog Path",MAIN_UDP_Selection_Path_Analog,""),IF(F4="Di gital Path",MAIN_UDP_Selection_Path_Digital,""),IF(F4="P assthrough Path",MAIN_UDP_Selection_Path_Passthrough,"")) It tells me I must reference a delimited list, or a single column or row when I try to put this formula in. All 3 named ranges are in the same column, but 2 of these ranges overlap slightly. I can list any of these named ranges as the source (i.e. =MAIN_UDP_Selection_Path_Analog) with no problems, but my formula doesnt seem to output a named range, or maybe its something else I'm missing. Any help would be appreciated. Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
[pivottables] multiple table selection fields update in one click... | Excel Discussion (Misc queries) | |||
Selection of multiple values for pivot table field | Excel Discussion (Misc queries) | |||
multiple pivots updated with selection in one table | Excel Worksheet Functions | |||
Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) | |||
Data Validation list selection question | Excel Worksheet Functions |