Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different Dependent Lists, based on value of first list
Hi,
I have two columns setup, both with data validation. The 2nd column is dependent upon the first , using the INDIRECT function in data validation. Question - if a particular value is chosen in the first column, can the dependnt list in the 2nd column be a different list? Example - If the first column is selected as GOOD, the 2nd column is going to pick from the named list of GOOD_CHOICES. If the first column is selected as BAD, then the 2nd column whould pict from the list named BAD_CHOISES. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different Dependent Lists, based on value of first list
Insert=Name=Define
Name: List2 Refersto: =Indirect(Sheet1!$A$1 & "_CHOICES") Then in the data validation, after you pick list, in the textbox put =List2 Works for me. -- Regards, Tom Ogilvy "Shelly" wrote in message ... Hi, I have two columns setup, both with data validation. The 2nd column is dependent upon the first , using the INDIRECT function in data validation. Question - if a particular value is chosen in the first column, can the dependnt list in the 2nd column be a different list? Example - If the first column is selected as GOOD, the 2nd column is going to pick from the named list of GOOD_CHOICES. If the first column is selected as BAD, then the 2nd column whould pict from the list named BAD_CHOISES. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Dependent lists based on the same list | Excel Worksheet Functions | |||
Data Validation & Dependent Lists -from same list? | Excel Worksheet Functions | |||
how do I generate lists in worksheets based on a master list works | Excel Worksheet Functions | |||
lists dependent on preceding list selection | Excel Discussion (Misc queries) | |||
Filling out list based on other lists | Excel Discussion (Misc queries) |