Posted 2/2/2019 09:51 (#7292026) Subject: Need Help with Dependent Drop Down List in Excel
I have attached my Excel worksheet. The data is in the "Data Table" tab.
I have made a dropdown list in cell A6 (None, Dry, Liquid).
I have also made a dropdown list in cell B6 that is dependent on what is selected in cell A6. If "Dry" is selected in A6 then only dry herbicides will be shown in B6, but if A6 is "Liquid" then only liquid herbicides will be shown in B6.
Now I want to make another dependent drop down list in cell D6. The problem is that I want this cell to be dependent on what is selected in A6. So when "Dry" is selected in A6, only dry forms of measurement are listed in D6 (oz/acre, lb/acre). Likewise when "Liquid" is selected in A6, only liquid forms of measurement are listed in D6 (floz/acre, pint/acre, quart/acre).
I have also attached the YouTube video explaining how I created the first two drop down lists. But I don't know how to make D6 dependent on a cell that is not beside it (C6).
I sure would appreciate any help. I have tried searching Google, but don't know what to call it so searches have not been successful.