Comparing two columns on sheet1 to two other columns on sheet2 and returning another column in sheet 2.
Solution 1:
Use the following formula:
=INDEX(Sheet2!$F$1:$F$100,MATCH(1,INDEX((Sheet2!$A$1:$A$100=A1)*(Sheet2!$B$1:$B$100=B1),),0))
Sheet 2 for reference
