AgTalk Home
AgTalk Home
Search Forums | Classifieds (187) | 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
 
Variorabbit
Posted 2/2/2019 17:28 (#7292671 - in reply to #7292026)
Subject: RE: Need Help with Dependent Drop Down List in Excel


South Dakota
I tested it using a nested if statement for the source in the data validation box. So in cell D6 run data validation and choose list like you did for the others and then in the source box paste what I have below. I took the forms of measurements that end up being displayed based off of the value in cell A6 form what you listed in your far right table on the data table tab. If you want to change them you just have to make sure the ranges displace in the formula below include the ones you want.

=IF(A6="Dry",'Data Table'!J3:J5,IF(A6="Liquid",'Data Table'!K3:K11)).

You can do a lot in excel with if/then statements.
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 all cookies set by this site)