Multiple dependent lists

[karl01]

Just a quick question is it possible to create drop down lists with a 1 to 4 relationship?

I.e. One parent list and 4 different child lists dependent on the parent?

How would i go about this if possible?

 

[Nebu]

Hi:

It is possible to do a dependent dropdown list.

Go through this link http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/ for further details

Thanks

 

[Basavaraj K H]

Hi
Kindly refer below link:

http://forum.chandoo.org/threads/re...tion-drop-down-depend-cell.24096/#post-145296

 

[karl01]

Thanks for your input guys. Much appreciated.

But is this possible with a fourth list specifically?

Most of the examples i can find are either two or three lists.

For example- can i have a main list, sub list 1, sub list 2, sublist 3 and sublist 4 that each contain different data based on the choice made from the main list options?

Hope this makes sense

Ive uploaded a sample with further explanation of what im trying to do.

 

[Nebu]

Hi:

What is wrong with the link I had given Jeff have clearly explained everything . I replicated his method without any hiccups.

Thanks

 

[karl01]

Thanks Nebu,

i understand what you were saying, i just wasn't sure how it worked with four sub lists specifically. I assume the formula is just replicated to add additional columns.

I work through it and try again with my example im trying to create.

Thanks again

 

[Nebu]

Hi:

The trick is the use of named ranges. If you can comprehend that formula it is fairly easy to replicate this.

Thanks