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.

--
Biff
Microsoft Excel MVP


"RickD" wrote in message
...
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.