A litle guidance

[kwdennis]

I want to do a two criteria match and then return multiple values form a third column



=IFERROR(INDEX(Quest_Data!$A$2:$A$1000,SMALL(IF(COUNTIF($B$5,Quest_Data!$B$2:$B$1000),ROW(Quest_Data!$A$2:$A$1000)-ROW(Quest_Data!A$2)+1),ROWS(A$5:A7))),"")



=INDEX(Quest_Data!$A$2:$A$1000,MATCH($B$5&$D$5,INDEX(Quest_Data!$B$2:$B$1000&Quest_Data!$C$2:$C$1000,),0))


any help would be much appreciated

 

[kwdennis]

Managed to sort this out

=IFERROR(INDEX(Quest_Data!$A$2:$A$1000,SMALL(IF(COUNTIF($B$5,Quest_Data!$B$2:$B$1000)*COUNTIF($D$5,Quest_Data!$C$2:$C$1000),ROW(Quest_Data!$B$2:$C$1000)-ROW(Quest_Data!A$2)+1),ROWS(A$1:A1))),"")


Allows for checking two criteria and returning a multiple values meeting those two criteria