I am making a document for my cabinet shop.
I have drop down lists so employees can select the cabinet wood (Cell A1), then the document using Indirect function only shows the door styles available in that wood type in the next drop down list (Cell A2).
Now my problem is I want to use another indirect function to show only the finishes (colors) available in that wood type.
How can I "link" my finishes (cell A3) to the wood type (Cell A1) when the door styles (Cell A2) is already linked to them?

Clear like mud!
Thanks!