Adding Match to an Index Formula

[Hatter]

I have the following index formula that finds and reports the number of lines within a Bill of Materials based upon a count.
=IF(ROWS(A$6:A6)<=$D$4,INDEX(BOMs!F$4:F$30890,SMALL(IF(BOMs!$B$4:$B$30890=$A$4,ROW(BOMs!$B$4:$B$30890)-ROW(BOMs!$A$4)+1),ROWS(A$6:A6))),"")
But i wanted to limit the number of results to a particular category, therefore i amended the count from =COUNTIFS(BOMs!$A:$A,$B$4) to =COUNTIFS(BOMs!$B:$B,$A$4,BOMs!$E:$E,$C$4) which in itself works, however the index only reports the count number of lines (in this case the first six lines) and doesn't recognise the category required hence why i want to add a Match into the formula, if that is the correct option.

 

[Fluff]

As you have 365 how about

=FILTER(BOMs!F4:F30890,(BOMs!B4:B30890=A4)*(BOMs!E4:E30890=C4))

 

[Hatter]

=FILTER(BOMs!F4:F30890,(BOMs!B4:B30890=A4)*(BOMs!E4:E30890=C4))

Thanks, it worked

 

[Fluff]

You're welcome & thanks for the feedback.