The title says it all.
I need to make a sheet with content areas that are dependent on the users selection from a drop down list.
I have considered nesting-ifs, but there are too many to nest. Also, this needs to be easily editable as it will be a template for many other users.
Example of what I am trying to do:
First drop down selection:
Selection: Category 1: Category 2:
Hello Bonjour Hola
Second drop down selection:
Selection: Category 1: Category 2:
Dog Chien Perro
So there is the example. When I select the word from the dropdown list (Hello or Dog), the result in each category should automatically appear. I need some help in making that happen.
Please help!
Bookmarks