View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RickD RickD is offline
external usenet poster
 
Posts: 2
Default 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.