The below formula only works with an array. However there are some #N/As. And when I try to add IFERROR using the second formula all the found matches turn to blanks. Any ideas what I could be doing wrong?
=INDEX(DETAIL!$F$2:$F$7474,MATCH(SUMMARY!$A3&E$2,DETAIL!$A$2:$A$7474&DETAIL!$D$2:$D$7474,0))
IFERROR(INDEX(DETAIL!$F$2:$F$7474,MATCH(SUMMARY!$A3&D$2,DETAIL!$A$2:$A$7474&DETAIL!$D$2:$D$7474,0)),"")
=INDEX(DETAIL!$F$2:$F$7474,MATCH(SUMMARY!$A3&E$2,DETAIL!$A$2:$A$7474&DETAIL!$D$2:$D$7474,0))
IFERROR(INDEX(DETAIL!$F$2:$F$7474,MATCH(SUMMARY!$A3&D$2,DETAIL!$A$2:$A$7474&DETAIL!$D$2:$D$7474,0)),"")