Forum Discussion
HOW TO DO A CONDITIONAL DROP DOWN MENU??
Hello Philip
First apologize for not answer you before. Thank you so much for your suggestions. They are pretty close to what i looking for.
The situation is that instead of having a first menu with only two options i have at list four options for the first menu and for the second menu i have more options. To give you an example i'm attaching a test sheet name "Prueba" with the menus i would like to appear.
In my example, what i'm looking for is when i select a product from the column name "Portafolio" then the second menu display the list of products that appears under that "Portafolio" i.e. if i choose "Plantas" from the portafolio menu, then in the column name "Producto" the list of items under the "Plantas" menu should be display, but if i choose from the "Portafolio" menu "Paneles", then all the list of items under the column name "Paneles" should be display in the second menu under the column "Producto", and so on.
That is what i try to achieve. As i said, your approch is very close to what i looking for. I´ve experimenting different type of ways to use your suggestion, however if you can give me a more finnish it idear will be much more appreciate.
Thank you so much for the time that you dedicate to this solution, and appreciate all the cooperation and help in this matter.
Hia,
try the attached. I think you were pretty close, but the bit's I've changed are:
I've made the options table just one table, you had 5 (1 for menu option). In order for it to work you need a single table where the column heading matches the option choices.
I changed the formula in the validation list, you were pointing it to A1, but your 'first choice' menu was in I3, so I pointed it to that.