Cascading Dropdown

%3CLINGO-SUB%20id%3D%22lingo-sub-2962455%22%20slang%3D%22en-US%22%3ECascading%20Dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2962455%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20can't%20even%20know%20how%20to%20start.%20Basically%2C%20I%20wanted%20to%20have%20cascading%20dropdowns%20on%20a%20tabular%20form.%20I%20have%20two%20sheets%20one%20is%20the%20lookup%20which%20is%20where%20the%20data%20will%20be%20coming%20from%20and%20one%20is%20the%20form%20from%20where%20the%20data%20should%20be%20displayed%20as%20a%20dropdown.%20The%20sample%20file%20is%20attached.%20Thanks%20in%20advance%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2962455%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2962484%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2962484%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1098170%22%20target%3D%22_blank%22%3E%40rbalza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%22ve%20never%20created%20a%20set%20of%20cascading%20drop%20downs%20as%20deep%20as%20you're%20trying%20to%20do%2C%20but%20I've%20done%20them%20three%20deep.%20They%20all%20follow%20the%20same%20conceptual%20frame.%20Here's%20an%20example%20only%20two%20deep.%20You%20can%20build%20on%20it.%20And%20with%20your%20table%20you%20already%20have%20a%20good%20start.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi everyone, can't even know how to start. Basically, I wanted to have cascading dropdowns on a tabular form. I have two sheets one is the lookup which is where the data will be coming from and one is the form from where the data should be displayed as a dropdown. The sample file is attached. Thanks in advance

1 Reply

@rbalza 

 

I"ve never created a set of cascading drop downs as deep as you're trying to do, but I've done them three deep. They all follow the same conceptual frame. Here's an example only two deep. You can build on it. And with your table you already have a good start.