use INDEX formula in Excel for gathering multiple search items

[Half Measures]

On the "List" worksheet, I have an inventory of Food, Music, Activity and Color that a Customer uses listed into columns. On a "Search" worksheet I have created PickLists cataloguing the Food, Music, Activity and Color available for Customers.

My goal with this is to create an INDEX formula for finding which Customers are utilizing a chosen item from the PickLists? These would be done by aligning the Row of a Customer and Item listed that they are using, from the "List" worksheet. A VLOOKUP formula only shows one result, and only shows the first one in the search. I’m looking for a way to result all the Customers using the chosen item.

I wanted to attach the Excel doc here that I'm talking about, for a better example. But, I couldn't find a way to do that. I'm new here. So, here are some screen-shot's visualizing what I'm talking about.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=FILTER(List!D1:D8,List!A1:A8=B3)

 

[Half Measures]

Hi & welcome to MrExcel.
How about

=FILTER(List!D1:D8,List!A1:A8=B3)

Eh...It's telling me that formula isn't valid.

 

[Half Measures]

Eh...It's telling me that formula isn't valid.

I tried FILETERXML instead, and it is only giving me a #VALUE! result.

 

[Fluff]

Eh...It's telling me that formula isn't valid.

Does it say the formula or function is not valid?

 

[Half Measures]

Does it say the formula or function is not valid?

formula

 

[Fluff]

So you get a message like

 

[Half Measures]

So you get a message like
View attachment 28084

I'm sorry...it says function not valid

 

[Fluff]

So it doesn't say formula then
How about in B7 dragged down

=IFERROR(INDEX(List!$D$1:$D$8,AGGREGATE(15,6,(ROW(List!$D$1:$D$8)-ROW(List!$D$1)+1)/(List!$A$1:$A$8=B3),ROWS(B$7:B7))),"")

 

[Half Measures]

So it doesn't say formula then
How about in B7 dragged down

=IFERROR(INDEX(List!$D$1:$D$8,AGGREGATE(15,6,(ROW(List!$D$1:$D$8)-ROW(List!$D$1)+1)/(List!$A$1:$A$8=B3),ROWS(B$7:B7))),"")

Eh...it's still only showing one result, even if more than one Customer uses the Food item.