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

@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

Related Conversations
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
12 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
SharePoint List Drag item Move error
mvas111 in SharePoint on
0 Replies