Need to create an index of all lines with a specific letter, need wildcards

[CheeseMan1]

I buy many kinds of products from many manufactures, I have a list like this

Cheese Manufacture

Mozzarella	A
Cheddar	A, B
Muenster	B,C
Jack	C
Colby	A, C
Swiss	D

<colgroup><col><col></colgroup><tbody>
</tbody>

I can easily find which manufacture makes each kind of cheese, I also need to know which cheese each manufacture makes, so if I were to type "A" in (A9) I would get line 1,2, and 5,

I have the following but 'IF" can't use wildcards so it will not find line 2 or 5
=INDEX($A$1:$C$8,SMALL(IF($B$1:$B$8=$A$9,ROW($B$1:$B$8)),ROW(List!1:1)),1)

 

[Weazel]

maybe something like...

D2=IFERROR(INDEX($A$2:$A$7,SMALL(IF(ISNUMBER(SEARCH($C$1,$B$2:$B$7)),ROW($A$2:$A$7)-ROW($A$2)+1),ROWS($D$2:D2))),"") Control Shift Enter

Row\Col	A​	B​	C​	D​
1​			a
2​	Mozzarella	A		Mozzarella
3​	Cheddar	A, B		Cheddar
4​	Muenster	B,C		Colby
5​	Jack	C
6​	Colby	A, C
7​	Swiss	D

<tbody>
</tbody>