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