CheeseMan1
New Member
- Joined
- Dec 30, 2016
- Messages
- 1
I buy many kinds of products from many manufactures, I have a list like this
Cheese Manufacture
<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)
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)