Dependent Lists from multiple values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a selection worksheet with 5 selection columns. Each column list
contents is dependent on the accumulated values in previous columns. IE:

MFG Brand Style Color Cost

I know how to use the "INDIRECT" function for making one list dependent on
another can not figure out how to make a list dependent on multiple other
list selectons. IE the content of the "Color" column is dependent on the MFG,
Brand and Style selections.

Any help would be greatly appreciated.
 
It's kind of hard to explain. So, here's a small sample file with 3
dependent lists.

http://cjoint.com/?jpeWdzfPOz

This file contains a macro. It simply clears the cells when a different
selection is made. To see the code select sheet1. Right click on the sheet
tab and select View Code.

Really, the hardest part to this is coming up with descriptive names and
building a cascading table. See sheet2 which contains the sources for the
lists. The cells highlighted in green represent the named ranges for each
level of dependence.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting drop-down menus 1
dependent drop down list 1
Data Validation & Dependent Lists -from same list? 5
2 Dependent lists based on the same list 1
Dependent drop down dynamic range formula, off sheet. 7
multiple dependent drop down lists 6
vlookup and validating data list 11
lookup multiple criteria 7

Back
Top