Hello All,

This is one of my first posts anywhere for anything. I've always been the type to research, Google and experiment to find answers, but this time I'm stumped...

I am trying to make dependent drop down lists which depend on 2 previous selections. I can't set up cascading dependencies (such as Country generates State selection which generates City) because I am working with a manufacturing process.

Example: Product A consists of 3 process steps: Assembly, Test, Verify. The selections for each step are unique and unique to Product A
Product B consists of 3 process steps: Assembly, Test, Verify. The selections for each step are unique and unique to Product B

I could create 3 worksheets (Assembly, Test and Verify) to remove a dependency, but that would make some of the later data collection more difficult. I want to be able to select the product and the product step to get a drop down specific to that action on that product, all in a single list. Is there a way to do this without VBA? I am not married to drop down lists and am open to other solutions.

Thanks.