Dependent drop-down list doesnt work with multiple statements

%3CLINGO-SUB%20id%3D%22lingo-sub-2439187%22%20slang%3D%22en-US%22%3EDependent%20drop-down%20list%20doesnt%20work%20with%20multiple%20statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2439187%22%20slang%3D%22en-US%22%3E%3CP%3EHopefully%20someone%20can%20help%20be!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20share%20the%20workbook%2C%20because%20it%20is%20company-sensitive.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20here's%20the%20issue%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EIm%20trying%20to%20create%20a%20dropdown%20list%20that%20is%20dependent%20oh%20three%20statements.%3C%2FLI%3E%3CLI%3EThe%20three%20statements%20can%20all%20be%20combined.%20Resulting%20in%206%20unique%20lists.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20wanna%20create%20a%20dependent%20dropdown%20showing%20me%20these%20lists%20based%20on%20the%20three%20statements.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20three%20statements%20are%20combined%20in%20a%20cell%20with%20%26amp%3B%22%22%26amp%3B.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cant%20get%20it%20to%20work!%20Anyone%20have%20an%20idea%20of%20how%20to%20get%20this%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2439187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2439278%22%20slang%3D%22en-US%22%3ERe%3A%20Dependent%20drop-down%20list%20doesnt%20work%20with%20multiple%20statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2439278%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076677%22%20target%3D%22_blank%22%3E%40Excel_newbie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20assign%20names%20to%20L12%3AL14%2C%20M12%3AM14%20etc.%20form%20L11%2C%20M11%20etc.%2C%20and%20use%20%3DINDIRECT(H9)%20as%20source%20for%20the%20data%20validation%20list.%20See%20the%20attached%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hopefully someone can help be! 

 

I cannot share the workbook, because it is company-sensitive. 

 

But here's the issue: 

 

  • Im trying to create a dropdown list that is dependent oh three statements.
  • The three statements can all be combined. Resulting in 6 unique lists.

I wanna create a dependent dropdown showing me these lists based on the three statements. 

The three statements are combined in a cell with &""&. 

 

I cant get it to work! Anyone have an idea of how to get this right?

 

 

1 Reply

@Excel_newbie 

You can assign names to L12:L14, M12:M14 etc. form L11, M11 etc., and use =INDIRECT(H9) as source for the data validation list. See the attached version.