I would like to create two drop-down lists. One drop-down list would contain the type of Dessert (see below - Ice Cream, Cookie, Jello. In the second drop-down list, I would like the user to only be permitted to select the flavor associated with the dessert he/she selected in the first drop-list.So if the user selects Ice Cream in the first drop-down, the options of Chocolate, Mint, Strawberry would appear in the second drop down. Thank you!
Hi,
The solution is as follows:
In the first dropdown list:
In the second dropdown list, put this formula in the data validation source:
=IF(D2="Ice Cream",B2:B4,IF(D2="Cookie",B5:B6,IF(D2="Jello",B7:B9)))
