Hello.

I'm attempting to pull data (from another sheet) into a cell with a drop down list.
I've managed to successfully get Index-Match to return the first option, but I have struggled getting multiple values.

Sheet1, labeled 'Cover', has Cells C16 and D16 that I want for drop-downs with options.
Sheet2, labeled 'DTB', has several columns of data. Column A has category "Type" Column B has Category "Name"
There are only 12 different types, but there are multiples of each type.
I put a data validation list in C16 with each of the types of category, as an indirect list (but if this is not needed, I don't mind cutting it).
I want to have D16 return a dynamic list of the names of the selected type in C16.

My goal is to have a vlookup function pull the correlating data after the "Name" is populated.


I currently have this in my data validation source box:
=INDEX(DTB!$B$1:$B$30,MATCH(C16,DTB!$A$1:$A$30,0))
It returns only the first value.
If I can, I'd like to avoid VBA