Drop-down list with sub list (in cascading format) or popup menu

0

Hello,

I am trying to make a list of things appear in a dropdown list (like the data validation list) and show its subcategories in the same list for example:

Categories: Fruit, Vegitables

Sub-categories: Apple, Banana, Cucumber, Brocoli

Sub-sub-category: Red Delicious, Gala, Granny Smith

So the list would ideally like: 

Vegitables > Cucumber

                  > Brocoli

Fruit > Banana

        >  Apple > Red Delicious

                      > Gala

                      > Granny Smith

I would like to avoid doing this in multiple columns, if this isn't possible is there a way to make a pop-up acheive the same goal?

Thanks!

Answer
Discuss

Answers

0

You can make a list that looks like that but it will be a lot more difficult to manage and update it.

Check the included spreadsheet.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login