Student needs help: Dynamic drop-downs.

[J.C.]

Hello people,

My name is JC, I'm an intern at a small company in the Netherlands.
Right now I need some help with my worksheet!

I'd like to create a 3 dependent drop-down lists with different data that all change based on 1 MAIN drop-down. So basically there are 4 columns next to each other...
I actually know how to do this by using this formula for the second column =INDIRECT(VLOOKUP($A2, Lists, COLUMN(B1), FALSE))

After choosing the type of medium (1st column, MAINList), the data in the 2nd, 3rd and 4th column will all be 'dependent' on this decision.
The thing is: the 4th column (CONTENT) has to be dependent on the choice made in the 3rd column (TERM).

So the 1st column is a Mainlist and the 3rd a Sublist? I looked at at this article but I can't figure it out...http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/

I really hope someone can help me with this. I uploaded the file so feel free to look I haven't defined all the lists yet btw...

J.C.

 

[jeffreyweir]

Hi JC. You've come to the right place...I wrote that article.

What part of it are you having trouble with? Have you tried overtyping the source data in the sample file at that blog post with your own? That might help you work out how it works.

 

[J.C.]

Hi Jeffrey,

I honestly have no idea where to begin. In contrast to your file, I have 3 worksheets. The sheets called 'sheet1' and 'data' will be hidden afterwards...so it's all about the 'Index' sheet and all the data will be defined in 'data'.

I'm also not using Excel Tables (is this necessary?). Plus, the 4th column must be dependent on the option made in the 3rd column....your worksheet has 3 columns with the 3rd one being dependent on the 2nd column so it's not totally the same.

Hopefully you can give this excel rookie some pointers! Could you look at my file and tell me how I should start? Especially the defining process is a bit hard for me to understand...thanks!