Drop down menu lists items from a table

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

Hi

In A1:A4 enter the values CT,FISH,DOG,SNAKE

Then highlight the range A2:A4 and define the name CT

In say D2 enter your data validation with list entries of CT,HQ. Pick CT
In E2 go data validation, list and in the source enter the formula
=INDIRECT($D$2)

Now when you select the dropdown in E2, the list from the named range CT is available.

HTH

rylo