Drop down menu list

%3CLINGO-SUB%20id%3D%22lingo-sub-2579019%22%20slang%3D%22en-US%22%3EDrop%20down%20menu%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2579019%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20created%20a%20drop%20down%20menu%20list%20as%20per%20attached...first%20on%20B12%20cell%20I%20select%20the%20model%20type%2C%20then%20on%20the%20cell%20B13%2C%20in%20Data%20Validation%2C%20I%20applied%20the%20formula%20%3DINDIRECT(%24B%2412)%20so%20I%20can%20get%20just%20the%20model%20A%20variant%20or%20just%20the%20model%20B%20variant%2C%20in%20B14%20I%20would%20a%20drop-down%20list%20that%3A%20if%20in%20B12%20is%20selected%20model%20A%2C%20I%20can%20just%20select%20the%20design%20stage%20a11%2C%20otherwise%20if%20in%20B12%20is%20selected%20model%20B%2C%20I%20can%20select%20or%20B11(standard)%20or%20B12...I%20tried%20to%20use%20again%20the%20formula%20with%20INDIRECT%20but%20without%20success...is%20there%20a%20way%20to%20do%20that%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2579019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2579235%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20menu%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2579235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1110122%22%20target%3D%22_blank%22%3E%40Klod1978%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20if%20the%20attached%20example%20can%20help%20you.%20It's%20what%20I%20call%20an%20example%20of%20cascading%20data%20validation%2C%20where%20the%20secondary%20selections%20change%20based%20on%20what%20was%20selected%20first.%20This%20uses%20the%20fairly%20recent%20Dynamic%20Array%20functions%2C%20so%20you%20will%20need%20to%20have%20the%20most%20current%20version%20of%20Excel%20for%20it%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20link%20will%20take%20you%20to%20a%20YouTube%20video%20that%20explains%20the%20Dynamic%20Array%20functions%20that%20are%20the%20foundations%20for%20the%20cascading%20data%20validation.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFeel%20free%20to%20come%20back%20with%20further%20questions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I created a drop down menu list as per attached...first on B12 cell I select the model type, then on the cell B13, in Data Validation, I applied the formula =INDIRECT($B$12) so I can get just the model A variant or just the model B variant, in B14 I would a drop-down list that: if in B12 is selected model A, I can just select the design stage a11, otherwise if in B12 is selected model B, I can select or B11(standard) or B12...I tried to use again the formula with INDIRECT but without success...is there a way to do that? Thanks

1 Reply

@Klod1978 

 

See if the attached example can help you. It's what I call an example of cascading data validation, where the secondary selections change based on what was selected first. This uses the fairly recent Dynamic Array functions, so you will need to have the most current version of Excel for it to work.

 

This link will take you to a YouTube video that explains the Dynamic Array functions that are the foundations for the cascading data validation.

https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Feel free to come back with further questions.

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...