In the old report, add a helper column that concatenates, A,E,F and H.... e.g =A2&"^^"&E2&"^^"&F2&"^^"&H2 copied down. Note, the ^^ in between is there to avoid false positives when comparing.
Now in new report you can use INDEX/MATCH
e.g. =IFERROR(INDEX('[OldReport.xlsx]Sheet1'!G:G,MATCH(A2&"^^"&E2&"^^"&F2&"^^"&H2,'[OldReport.xlsx]Sheet1'!I:I,0)),"") copied down
where I:I is the column you used as a helper in the old report. Change workbook name, sheetname name and references to suit.
Bookmarks