I have a pretty good formula to select data based on one criteria. I would like to add a second criteria to my list.

{=INDEX($I:$I,SMALL(IF($L:$L=$B$2,ROW(I:I)+0),ROW(I1)))}

I use this formula to reference $B$2 which limits my results. I want to add another criteria and use $B$2 and $C$2 to limit results.

Please see attached.


Array Formula Multiple Criteria.xlsx