I'd like to have a drop down menu where I can pick a item, and then have it list all corresponding items in another block(s)
In my example I have attached:
I'd like to have a drop down menu with CT and HQ as the seperate options to pick from.
When for example I pick CT. I'd like a list of "FISH", "DOG", "SNAKE" to appear in a cell or Cells.
I've been using =index functions to get it to appear so far.
thanks
Nate
Bookmarks