| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation & Dependent Lists -from same list?
Using the instructions on Contextures.com about Data Validation & Dependant
Lists, I have created a form that contains the following columns with drop down options: (in columns A - B - C) Category - Parameters - Methods Category is the parent list and the lists for Parameters and for Methods are dependant on Category. In the cells for Parameters, I have used the Validation function =INDIRECT(A2). So depending on what I choose under category, the corresponding list shows up as options in the Parameters column. Perfect! Now, the problem is that I don't know how to associate the my list for methods with the same category. For example: My drop down options under Category (column A) a Shoes Shirts Pants If Shoes are chosen for the category, the Parameters options (col. B) would be: Pumps Loafers Boots If Shoes are chosen as the Category, the Method options (col. C) would be: Lace Up High Heel Low Heel Flats I can't figure out how to associate column C with the list in Column A and have it show the right data (as opposed to showing the same options in Col. B). Any help would be greatly appreciated! -D |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation & Dependent Lists -from same list?
This link maybe useful to you.
http://www.ozgrid.com/Excel/dependent-lists.htm Muppet Man On Sep 25, 7:31*pm, blucajun wrote: Using the instructions on Contextures.com about Data Validation & Dependant Lists, I have created a form that contains the following columns with drop down options: (in columns A - B - C) Category - Parameters - Methods Category is the parent list and the lists for Parameters and for Methods are dependant on Category. *In the cells for Parameters, I have used the Validation function =INDIRECT(A2). *So depending on what I choose under category, the corresponding list shows up as options in the Parameters column. *Perfect! *Now, the problem is that I don't know how to associate the my list for methods with the same category. *For example: My drop down options under Category (column A) a Shoes Shirts Pants If Shoes are chosen for the category, the Parameters options (col. B) would be: Pumps Loafers Boots If Shoes are chosen as the Category, the Method options (col. C) would be: Lace Up High Heel Low Heel Flats I can't figure out how to associate column C with the list in Column A and have it show the right data (as opposed to showing the same options in Col. B). *Any help would be greatly appreciated! -D |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation & Dependent Lists -from same list?
Thanks for the link but unless I'm missing something, it explains how to do
what I already learned from Contextures.com. Or maybe I didn't explain myself clearly. I already have the dropdown options in column B dependant on the selection in column A. What I now need is to have the dropdown options in column C (which are different than Col. B) dependant on the selection in column A also. " wrote: This link maybe useful to you. http://www.ozgrid.com/Excel/dependent-lists.htm Muppet Man On Sep 25, 7:31 pm, blucajun wrote: Using the instructions on Contextures.com about Data Validation & Dependant Lists, I have created a form that contains the following columns with drop down options: (in columns A - B - C) Category - Parameters - Methods Category is the parent list and the lists for Parameters and for Methods are dependant on Category. In the cells for Parameters, I have used the Validation function =INDIRECT(A2). So depending on what I choose under category, the corresponding list shows up as options in the Parameters column. Perfect! Now, the problem is that I don't know how to associate the my list for methods with the same category. For example: My drop down options under Category (column A) a Shoes Shirts Pants If Shoes are chosen for the category, the Parameters options (col. B) would be: Pumps Loafers Boots If Shoes are chosen as the Category, the Method options (col. C) would be: Lace Up High Heel Low Heel Flats I can't figure out how to associate column C with the list in Column A and have it show the right data (as opposed to showing the same options in Col. B). Any help would be greatly appreciated! -D |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation & Dependent Lists -from same list?
Create the lists of methods associated with the categories and name them
like this: Shoes_method Shirts_method Pants_method Then, as the source for the drop down in column C use: =INDIRECT(A1&"_method") -- Biff Microsoft Excel MVP "blucajun" wrote in message ... Using the instructions on Contextures.com about Data Validation & Dependant Lists, I have created a form that contains the following columns with drop down options: (in columns A - B - C) Category - Parameters - Methods Category is the parent list and the lists for Parameters and for Methods are dependant on Category. In the cells for Parameters, I have used the Validation function =INDIRECT(A2). So depending on what I choose under category, the corresponding list shows up as options in the Parameters column. Perfect! Now, the problem is that I don't know how to associate the my list for methods with the same category. For example: My drop down options under Category (column A) a Shoes Shirts Pants If Shoes are chosen for the category, the Parameters options (col. B) would be: Pumps Loafers Boots If Shoes are chosen as the Category, the Method options (col. C) would be: Lace Up High Heel Low Heel Flats I can't figure out how to associate column C with the list in Column A and have it show the right data (as opposed to showing the same options in Col. B). Any help would be greatly appreciated! -D |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation & Dependent Lists -from same list?
This worked perfectly. Thanks so much!
"T. Valko" wrote: Create the lists of methods associated with the categories and name them like this: Shoes_method Shirts_method Pants_method Then, as the source for the drop down in column C use: =INDIRECT(A1&"_method") -- Biff Microsoft Excel MVP "blucajun" wrote in message ... Using the instructions on Contextures.com about Data Validation & Dependant Lists, I have created a form that contains the following columns with drop down options: (in columns A - B - C) Category - Parameters - Methods Category is the parent list and the lists for Parameters and for Methods are dependant on Category. In the cells for Parameters, I have used the Validation function =INDIRECT(A2). So depending on what I choose under category, the corresponding list shows up as options in the Parameters column. Perfect! Now, the problem is that I don't know how to associate the my list for methods with the same category. For example: My drop down options under Category (column A) a Shoes Shirts Pants If Shoes are chosen for the category, the Parameters options (col. B) would be: Pumps Loafers Boots If Shoes are chosen as the Category, the Method options (col. C) would be: Lace Up High Heel Low Heel Flats I can't figure out how to associate column C with the list in Column A and have it show the right data (as opposed to showing the same options in Col. B). Any help would be greatly appreciated! -D |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation & Dependent Lists -from same list?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "blucajun" wrote in message ... This worked perfectly. Thanks so much! "T. Valko" wrote: Create the lists of methods associated with the categories and name them like this: Shoes_method Shirts_method Pants_method Then, as the source for the drop down in column C use: =INDIRECT(A1&"_method") -- Biff Microsoft Excel MVP "blucajun" wrote in message ... Using the instructions on Contextures.com about Data Validation & Dependant Lists, I have created a form that contains the following columns with drop down options: (in columns A - B - C) Category - Parameters - Methods Category is the parent list and the lists for Parameters and for Methods are dependant on Category. In the cells for Parameters, I have used the Validation function =INDIRECT(A2). So depending on what I choose under category, the corresponding list shows up as options in the Parameters column. Perfect! Now, the problem is that I don't know how to associate the my list for methods with the same category. For example: My drop down options under Category (column A) a Shoes Shirts Pants If Shoes are chosen for the category, the Parameters options (col. B) would be: Pumps Loafers Boots If Shoes are chosen as the Category, the Method options (col. C) would be: Lace Up High Heel Low Heel Flats I can't figure out how to associate column C with the list in Column A and have it show the right data (as opposed to showing the same options in Col. B). Any help would be greatly appreciated! -D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation dependent lists | Excel Discussion (Misc queries) | |||
| dependent lists on data validation | Excel Discussion (Misc queries) | |||
| Data Validation and Dependent Lists Q | Excel Worksheet Functions | |||
| Data Validation & Dependent Lists | Excel Worksheet Functions | |||
| Data Validation - Create dependent lists | Excel Discussion (Misc queries) | |||
Linear Mode
