Index match 2 items returning multiple results & search for partial text

[billrogers184]

I'm trying to create various methods of searching the same data using different criteria.

One method is using the index match function to return other cell information by matching 2 criteria. I can get it to return results if the criteria are unique. However, sometimes I have different results which are not returned because the index match stops at the first "true" match. See cell I2-I5.

Secondly, I'm trying to search for partial text in a column (see cell L2) by searching for the text criteria I enter in L1.

Thank you for any guidance and support.

[Bo_Ry]

Please try at
H2
=IF(ROWS(H$1:H1)>COUNTIFS($B$1:$B$45,$H$1),"",INDEX(C$1:C$45,SMALL(IF($B$1:$B$45=$H$1,ROW($B$1:$B$45)),ROWS(H$1:H1))))
Confirm by Ctrl+Shift+Enter
copy to H2:L45

L2
=IF(ROWS(L$2:L2)>COUNTIF($C$1:$C$45,"*"&$L$1&"*"),"",INDEX($A$1:$D$45,SMALL(IF(ISNUMBER(SEARCH($L$1,$C$1:$C$45)),ROW($C$1:$C$45)),ROWS(L$2:L2)),COLUMNS($L2:L2)*3-2))

Confirm by Ctrl+Shift+Enter
copy to L2:M45

[billrogers184]

AWESOME! Thank You!