Home

Data Validation multiple lists

%3CLINGO-SUB%20id%3D%22lingo-sub-584309%22%20slang%3D%22en-US%22%3EData%20Validation%20multiple%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-584309%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20how%20to%20create%20a%20single%20drop%20down%20list%20but%20i%20am%20trying%20to%20create%20a%20form%20that%20if%20you%20select%20an%20option%20from%20the%20first%20drop%20down%20list%20it%20will%20allow%20you%20to%20only%20select%20from%20a%20corresponding%20second%20drop%20down%20list%20only%20the%20options%20that%20apply%20based%20on%20your%20answer%20on%20the%20first%20selection.%20My%20form%20does%20not%20have%20headers%20on%20it%20either%20and%20from%20everything%20I%20can%20see%20online%20they%20all%20have%20headers.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-584309%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-584322%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20multiple%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-584322%22%20slang%3D%22en-US%22%3EYou%20may%20check%20my%20reply%20in%20this%20link%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FDependent-Drop-down-List-Formula-for-only-showing-cells-with%2Fm-p%2F355193%23M26086%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FDependent-Drop-down-List-Formula-for-only-showing-cells-with%2Fm-p%2F355193%23M26086%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-584337%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20multiple%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-584337%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20links%20but%20I%20still%20dont%20understand%20how%20to%20create%20the%20formulas%20to%20complete%20this%20also%20I%20do%20not%20want%20headers%20on%20my%20main%20page.%20I%20want%20it%20so%20if%20I%20where%20to%20select%20Candy%20the%20next%20box%20will%20show%20the%20types%20of%20candy%20all%20with%20out%20headers%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-584351%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20multiple%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-584351%22%20slang%3D%22en-US%22%3EYou%20can%20remove%20the%20headers%20if%20you%20want.%20If%20you%20can%20attach%20your%20sample%20file%2C%20I%20can%20create%20the%20drop-down%20lists%20for%20you.%3C%2FLINGO-BODY%3E
thman00
New Contributor

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
Highlighted

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.
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies