Forum Discussion
thman00
May 18, 2019Copper Contributor
Data Validation multiple lists
I know how to create a single drop down list but i am trying to create a form that if you select an option from the first drop down list it will allow you to only select from a corresponding second drop down list only the options that apply based on your answer on the first selection. My form does not have headers on it either and from everything I can see online they all have headers.
3 Replies
- TwifooSilver ContributorYou may check my reply in this link:
https://techcommunity.microsoft.com/t5/Excel/Dependent-Drop-down-List-Formula-for-only-showing-cells-with/m-p/355193#M26086- TwifooSilver ContributorYou can remove the headers if you want. If you can attach your sample file, I can create the drop-down lists for you.