Forum Discussion
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 d...
You 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
https://techcommunity.microsoft.com/t5/Excel/Dependent-Drop-down-List-Formula-for-only-showing-cells-with/m-p/355193#M26086
Thanks for the links but I still dont understand how to create the formulas to complete this also I do not want headers on my main page. I want it so if I where to select Candy the next box will show the types of candy all with out headers Twifoo
- You can remove the headers if you want. If you can attach your sample file, I can create the drop-down lists for you.
