AgTalk Home
AgTalk Home
Search Forums | Classifieds (170) | Skins | Language
You are logged in as a guest. ( logon | register )

Need Help with Dependent Drop Down List in Excel
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
mohr-power
Posted 2/2/2019 09:51 (#7292026)
Subject: Need Help with Dependent Drop Down List in Excel


West-Central IL

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.

https://www.youtube.com/watch?v=za23lyAEvLY





Attachments
----------------
Attachments Auto Spray Batch Calculator Ag Talk Version.xlsx (15KB - 634 downloads)
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)