Try the following as an array formula (which you input with Ctrl-Shift-Enter):
Code:
=INDEX('Report 2'!C:C,(MATCH('Report 1'!A2&'Report 1'!F2,'Report 2'!A:A&'Report 2'!D:D,0)))
Note: I haven't tried to suppress the errors that occur when no match occurs. Doing so is quite simple.