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
=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