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

enter image description here


Sheet 2 for reference

enter image description here