Home

Drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-797625%22%20slang%3D%22en-US%22%3EDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797625%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20dependent%20drop%20down%20list%20but%20at%20the%20same%20time%20I%20want%20them%20to%20be%20automated%20(if%20possible).%20For%20example%2C%20say%20I've%20got%20a%20list%20of%205%20car%20makers%20in%20my%20main%20drop%20down.%20Then%20I'll%20get%20to%20choose%20the%20models%20in%20the%202nd%20drop%20down.%20Once%20I've%20selected%20a%20specific%20model%2C%20I%20want%20the%20features%2Fdetails%20of%20this%20model%20to%20show%20up%20in%20the%203rd%20or%204th%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20this%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-797625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797725%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389922%22%20target%3D%22_blank%22%3E%40deedz7%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20can%20be%20done%20by%20some%20tricks%20in%20data%20validations%20which%20involve%20the%20named%20ranges%20and%20INDIRECT%20function.%3C%2FP%3E%3CP%3EWatch%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-78bH0RZ7MA%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Evideo%3C%2FA%3Eto%20learn%20these%20tricks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
deedz7
Occasional Visitor

I want to create dependent drop down list but at the same time I want them to be automated (if possible). For example, say I've got a list of 5 car makers in my main drop down. Then I'll get to choose the models in the 2nd drop down. Once I've selected a specific model, I want the features/details of this model to show up in the 3rd or 4th column.

 

Can this be done?

1 Reply

@deedz7

 

Hi,

 

This is can be done by some tricks in data validations which involve the named ranges and INDIRECT function.

Watch this video to learn these tricks.

 

Regards