SOLVED

Multiple Drop Down Lists

%3CLINGO-SUB%20id%3D%22lingo-sub-1561725%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Drop%20Down%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F141503%22%20target%3D%22_blank%22%3E%40ahmad%20ali%3C%2FA%3E%26nbsp%3B%2C%20Something%20like%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561770%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Drop%20Down%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561770%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3B%20so%20much%3C%2FP%3E%3CP%3EYes%2Cexactly%20like%20that%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%2CI%20have%20questions%3A%3C%2FP%3E%3CP%3E1-%20the%20tables%20you%20inserted%20have%20filters%20signs%20(%20though%20columns%20are%20not%20filtered)%20-%20are%20they%20necessary%3F%3C%2FP%3E%3CP%3E2-%20The%20way%20you%20got%20column%20P%20is%20that%20you%20copied%20column%20B%20(B6%3AB32)%20then%20you%20applied%20(remove%20duplicates)%20then%20you%20inserted%20column%20O%20accordingly(cell%20by%20cell)%20-%20%3Fright%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561779%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Drop%20Down%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561779%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F141503%22%20target%3D%22_blank%22%3E%40ahmad%20ali%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EI%20made%20the%20helper%20tables%20into%20official%20Excel%20Tables%20(Insert-%26gt%3BTable)%20so%20that%20they%20will%20expand%20dynamically%20and%20the%20formulas%20that%20reference%20it%20will%20also%20expand%20accordingly.%20They%20are%20necessary%20if%20your%20list%20may%20grow%20in%20the%20future.%26nbsp%3B%3C%2FLI%3E%3CLI%3ECorrect.%20I%20copied%20over%20unique%20values%20so%20I%20can%20lookup%20for%20the%20dynamic%20drop-downs%20in%20the%20Data%20Validation%20Formula.%20I%20did%20this%20because%20you%20had%20mentioned%20you%20were%20using%20Excel%202016%20so%20you%20wouldn't%20have%20the%20latest%20Excel%20functions%20like%20Filter%20and%20Unique.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561788%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Drop%20Down%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561788%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%3C%2FP%3E%3CP%3EI%20can't%20thank%20you%20enough%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561606%22%20slang%3D%22en-US%22%3EMultiple%20Drop%20Down%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561606%22%20slang%3D%22en-US%22%3ESOLVED%3CP%3EHello%2C%3C%2FP%3E%3CP%3Ecould%20you%20please%20help%20me%20in%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edepending%20to%20the%20data%20in%20the%20Table%201%20%2C%3CBR%20%2F%3Ecreate%20dynamic%20drop%20down%20list%20to%20be%20ability%20filling%20the%20Table%202%20according%20to%20administrative%20division%20to%20three%20level%20%2C%20each%20admin%20level%20depends%20on%20the%20previous%20admin%20level%3C%2FP%3E%3CP%3E(please%20see%20the%20file%20attached)%20note%3A%20I%20use%20Excel%202016.%3C%2FP%3E%3CP%3Ethanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1561606%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561830%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Drop%20Down%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561830%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F141503%22%20target%3D%22_blank%22%3E%40ahmad%20ali%3C%2FA%3E%26nbsp%3B%2C%20happy%20to%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1876062%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Drop%20Down%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1876062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3BHi%2C%3C%2FP%3E%3CP%3ECan%20you%20suggest%20me%20a%20way%20to%20create%20a%20troubleshooting%20guide%20with%20dropdown%20lists.%3CBR%20%2F%3EThe%20issues%20will%20be%20categorized%20and%20when%20user%20selects%20a%20category%20it%20will%20show%20the%20next%20level%20of%20classification%20and%20at%20the%20end%20of%20hierarchy%20the%20issue%20will%20be%20there%20along%20with%20the%20solution.%3CBR%20%2F%3EHere%20we%20need%20multiple%20drop%20down%20lists%26nbsp%3B%3CBR%20%2F%3Ethe%20values%20of%20seconf%20dropdown%20should%20be%20dependant%20on%20the%20value%20selected%20in%20the%20first%20dropdown%3CBR%20%2F%3Ethe%203rd%20dropdown%20should%20be%20dependant%20on%20the%20value%20selected%20in%201st%20dropdown%20and%20so%20on%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor
SOLVED

Hello,

could you please help me in this:

 

depending to the data in the Table 1 ,
create dynamic drop down list to be ability filling the Table 2 according to administrative division to three level , each admin level depends on the previous admin level

(please see the file attached) note: I use Excel 2016.

thanks!

6 Replies
Best Response confirmed by ahmad ali (Contributor)
Solution

@ahmad ali , Something like this?

Thanks @TheAntony  so much

Yes,exactly like that

 

please,I have questions:

1- the tables you inserted have filters signs ( though columns are not filtered) - are they necessary?

2- The way you got column P is that you copied column B (B6:B32) then you applied (remove duplicates) then you inserted column O accordingly(cell by cell) - ?right

 

thanks!

 

 

@ahmad ali ,

 

  1. I made the helper tables into official Excel Tables (Insert->Table) so that they will expand dynamically and the formulas that reference it will also expand accordingly. They are necessary if your list may grow in the future. 
  2. Correct. I copied over unique values so I can lookup for the dynamic drop-downs in the Data Validation Formula. I did this because you had mentioned you were using Excel 2016 so you wouldn't have the latest Excel functions like Filter and Unique.

@TheAntony 

Thank you so much

I can't thank you enough 

 

@ahmad ali , happy to help. 

@TheAntony Hi,

Can you suggest me a way to create a troubleshooting guide with dropdown lists.
The issues will be categorized and when user selects a category it will show the next level of classification and at the end of hierarchy the issue will be there along with the solution.
Here we need multiple drop down lists 
the values of seconf dropdown should be dependant on the value selected in the first dropdown
the 3rd dropdown should be dependant on the value selected in 1st dropdown and so on