Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent drop-down list??
I am using a drop-down list for data validation in a column. Can I make the
drop-down list in another column dependent on the contents of the first column? Example: Col A has a list defined: Fruit Vegetable If the user selects fruit, then in Column B the list is: Apple pear If the user selects Vegetable, then the column B list is: Peas Carrots thanks John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent drop-down list??
Check out this page from Debra Dalgleish's web site:
http://www.contextures.com/xlDataVal13.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DocBrown" wrote in message ... I am using a drop-down list for data validation in a column. Can I make the drop-down list in another column dependent on the contents of the first column? Example: Col A has a list defined: Fruit Vegetable If the user selects fruit, then in Column B the list is: Apple pear If the user selects Vegetable, then the column B list is: Peas Carrots thanks John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent drop-down list??
This is great! I think this is on the right track... One 'small' follow
question. This procedure is based on simple entries in the first list able to match a list name for the second column. How can this be modified if the actual cell entry is more complicated such as: Col A list: IP3list Bad or missing patch/update Configuration Issue Col B lists: IP4list1 Patch had been flagged bad Patch had not been flagged bad IP4list2 Command line interface - Documentation Command line interface too complex Configuration too complex GUI clumsy/slow GUI missing options GUI not intuitive User training John "Ragdyer" wrote: Check out this page from Debra Dalgleish's web site: http://www.contextures.com/xlDataVal13.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DocBrown" wrote in message ... I am using a drop-down list for data validation in a column. Can I make the drop-down list in another column dependent on the contents of the first column? Example: Col A has a list defined: Fruit Vegetable If the user selects fruit, then in Column B the list is: Apple pear If the user selects Vegetable, then the column B list is: Peas Carrots thanks John |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent drop-down list??
I read the page a little closer and saw how to do this. It works GREAT!
It the option on the page with the =INDIRECT(VLOOKUP.... formula. Thanks a bunch for the pointer. John "DocBrown" wrote: This is great! I think this is on the right track... One 'small' follow question. This procedure is based on simple entries in the first list able to match a list name for the second column. How can this be modified if the actual cell entry is more complicated such as: Col A list: IP3list Bad or missing patch/update Configuration Issue Col B lists: IP4list1 Patch had been flagged bad Patch had not been flagged bad IP4list2 Command line interface - Documentation Command line interface too complex Configuration too complex GUI clumsy/slow GUI missing options GUI not intuitive User training John "Ragdyer" wrote: Check out this page from Debra Dalgleish's web site: http://www.contextures.com/xlDataVal13.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DocBrown" wrote in message ... I am using a drop-down list for data validation in a column. Can I make the drop-down list in another column dependent on the contents of the first column? Example: Col A has a list defined: Fruit Vegetable If the user selects fruit, then in Column B the list is: Apple pear If the user selects Vegetable, then the column B list is: Peas Carrots thanks John |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent drop-down list??
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DocBrown" wrote in message ... I read the page a little closer and saw how to do this. It works GREAT! It the option on the page with the =INDIRECT(VLOOKUP.... formula. Thanks a bunch for the pointer. John "DocBrown" wrote: This is great! I think this is on the right track... One 'small' follow question. This procedure is based on simple entries in the first list able to match a list name for the second column. How can this be modified if the actual cell entry is more complicated such as: Col A list: IP3list Bad or missing patch/update Configuration Issue Col B lists: IP4list1 Patch had been flagged bad Patch had not been flagged bad IP4list2 Command line interface - Documentation Command line interface too complex Configuration too complex GUI clumsy/slow GUI missing options GUI not intuitive User training John "Ragdyer" wrote: Check out this page from Debra Dalgleish's web site: http://www.contextures.com/xlDataVal13.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DocBrown" wrote in message ... I am using a drop-down list for data validation in a column. Can I make the drop-down list in another column dependent on the contents of the first column? Example: Col A has a list defined: Fruit Vegetable If the user selects fruit, then in Column B the list is: Apple pear If the user selects Vegetable, then the column B list is: Peas Carrots thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Order of drop down list | Excel Discussion (Misc queries) | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
How do I create a dependent list, to a current list? | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |