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
Highlighted
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

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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies