Dependent dropdowns Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2501698%22%20slang%3D%22en-US%22%3EDependent%20dropdowns%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501698%22%20slang%3D%22en-US%22%3E%3CP%3EBest%2C%3CBR%20%2F%3EIs%20it%20possible%20to%20connect%203%20dropdowns%20with%20each%20other.%20Independence.%3C%2FP%3E%3CP%3EEg.%3CBR%20%2F%3EField%201%20has%20as%20dropdown%20values%20%3D%20Cat1%20%2F%20Cat2%20%2F%20Cat3%3CBR%20%2F%3EField%202%20%3A%20of%20which%20the%20value%20depends%20on%20what%20chosen%20in%20field%201%20(Step1.CAT1%20%2F%20Step2.CAT1%20%2F%20Step3%2FCAT3)%3CBR%20%2F%3EField%203%3A%20the%20value%20of%20this%20field%20depends%20on%20what%20is%20selected%20in%20field%201%20and%20field%202%3C%2FP%3E%3CP%3EI%20get%20this%20done%20with%20dget%20but%20disadvantage%20of%20this%20is%20that%20I%20cannot%20copy%20it%20to%20multiple%20lines.%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2501698%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-2501740%22%20slang%3D%22en-US%22%3ERe%3A%20Dependent%20dropdowns%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501740%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1092006%22%20target%3D%22_blank%22%3E%40Segeyuti%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20workbook%20for%20a%20small%20example%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2501877%22%20slang%3D%22en-US%22%3ERe%3A%20Dependent%20dropdowns%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501877%22%20slang%3D%22en-US%22%3EThanks%20a%20lot%20!%3CBR%20%2F%3EWould%20it%20also%20be%20possible%20that%20the%20third%20field%20is%20filled%20in%20automatically%20based%20on%20the%20value%20in%20field2%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E
New Contributor

Best,
Is it possible to connect 3 dropdowns with each other. Independence.

Eg.
Field 1 has as dropdown values = Cat1 / Cat2 / Cat3
Field 2 : of which the value depends on what chosen in field 1 (Step1.CAT1 / Step2.CAT1 / Step3/CAT3)
Field 3: the value of this field depends on what is selected in field 1 and field 2

I get this done with dget but disadvantage of this is that I cannot copy it to multiple lines.

Thanks in advance.

 

4 Replies

@Segeyuti 

See the attached workbook for a small example

Thanks a lot !
Would it also be possible that the third field is filled in automatically based on the value in field2
Thanks

@Segeyuti 

Here is an example, I don't know if it fits ... to be honest I haven't read everything

... well maybe that helps too :)).

 

Thank you for your understanding and patience

 

Wish you a nice day.

 

Nikolino

I know I don't know anything (Socrates)

@Segeyuti 

So in fact, you want two drop downs plus one value depending on those.

Here is a modified example.