Dropdown, depening on other dropdown?

[horsefish01]

Is there somhowe I can restrict LVL 2 dropdown, based on LVL 1?

So for instance, if they choose "1" from LVL 1, they'll only be able to choose from all the a's from DATA-sheet, and so on?

DROPDOWNS.xlsx

[ChemistB]

Assuming there are no spaces in the choices for Lvl1 (e.g. 1 doesn't = "Green cars") then name your 3 lvl2 lists by whatever 1,2, and 3 are in Lvl1.
Then your data validation will be Lists = INDIRECT(E13)
Questions?

[JohnTopley]

See attached (as an example)

LVL 1 DV list changed to "A", "B" "C"

Lvl 2 named ranges "LVLA", "LVLB", LVLC"

for Data Validation for LVL 2

=List

source : =INDIRECT("LVL" & E13)

[ChemistB]

Another option, since your question is a little vague, let's say the initial dropdown is 1,2 or 3

Define Data!E13:G23 as MyData

Your Lvl2 dropdown would be
List = INDEX(MyData, 0, E13)
See attachment

[horsefish01]

Thanks guys.

But what if the data not that "simple"

LVL 1 can be 12 different sentences, LVL 2 100 of sentences in each dropdown

Like LVL1 could be "Arm Ref"

LVL 2 could then be a ton 2-5 word combos with no system at all

[JohnTopley]

Why provide a sample which is NOT representative of what you require?

Please post a representative file of your data.

[ChemistB]

So let's say Level 1 dropdown is a list called Lvl1
Then similar to post #4 but

List = INDEX(MyData, 0, MATCH(E13, Lvl1,0))

[horsefish01]

I'm sorry.

I was hoping it would be the "same" solution, and I could see trough it. - and the book it's about has to much data in it to share. I've made this instead.

So if they choose in A->B should be only C,E or G

[ChemistB]

You lost me. So in Ark2, A2, I pick Ebs, Then in B2, What are my options and how does that relate to A2 (and why)?

See attached. In this example, Lvl1 can be as complex as you want. If you choose the first choice, then on Lvl2 you choose from 1st column, 2nd choice, 2nd column and so on.

If your dynamics are different (i.e. 1st 3 choices are first column, next 3 are second column and so on), formula can be adapted.

[horsefish01]

Sorry - wrong edition
-thanks for sticking with me!

Drip.xlsx

I'm looking at yours, and just cant get the same result! :-/

Is it because of the gaps/columns between tables?

[ChemistB]

Okay, the validation in Ark2 Column B beginning at B2

=OFFSET('Ark1'!$B$3, 0, MATCH(A2, 'Ark1'!$C$2:$G$2,0), COUNTA(OFFSET('Ark1'!$B$3:$B$1000, 0, MATCH(A2, 'Ark1'!$C$2:$G$2,0))),1)

[ChemistB]

My post from #9 will work except you have different ranges in different columns. This new formula takes care of that.

[horsefish01]

Thanks a million buddy :D <3