Array formula with 2 if conditions

[spoursy]

I use an array formula to look through a list of data and then return, in a list without blanks, all the row references where a criteria has been met. In this case the list is d3:d188 and the criteria is set in c8

=IFERROR(SMALL(IF(ISNUMBER(FIND($C$8,Sheet5!$D$3:$D$188)),ROW(Sheet5!$D$3:$D$188)-ROW($C$8)+1,""),ROW(7:7))+1,"")

What I would like to do is to add an aditional criteria into the formula which searches another list - the list is in column i between the same rows. If both criterias are met I need to know the row references where this criteria is metArray example for excel forum.xlsx

[JohnTopley]

Try

=IFERROR(SMALL(IF((ISNUMBER(FIND($C$8,Sheet5!$D$3:$D$188)))*(Sheet5!$I$3:$I$188="672"),ROW(Sheet5!$D$3:$D$188)-ROW($C$3)+1,""),ROWS($D$3:D3)),"")

[spoursy]

Excellent - Solved - R