Nested lists (INDIRECT FUNCTION)

[ibabs]

Hello,

I am trying to learn how to create a list, that's nested in another list? I think that's what it might be called.
Basically I have a workbook with 2 sheets (form and names) - see attached files

In the names sheet...I have categories for types of animals (dogs, cats, rabbits) and then I have a list of names for each type of animal.

In the Forms sheet, I have a column that uses a list validation to choose the type of animal from the drop down menu and that is working fine.

What I want to achieve is, to the right of that cell, when I choose a type (category) of an animal, that only those names for that type show up in a drop down menu.

So, if someone chooses "dogs" from the cell on the left, I want only the dogs names to populate on the right.

I found something online using the INDIRECT function, but I can't seem to get it to work.

Right now each type of animals names uses a name range to identify that group.

Any help is greatly appreciate
thanks
babs