Dependent Lists from multiple values
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.
|