try the below array formula in I1 and drag it to j1

Formula: copy to clipboard 
=INDEX(Sheet2!$I$1:$J$100,MATCH(1,(Sheet2!$A$1:$A$100=Sheet1!$A1)*(Sheet2!$B$1:$B$100=Sheet1!$B1)*(Sheet2!$C$1:$C$100=Sheet1!$C1)*(Sheet2!$D$1:$D$100=Sheet1!$D1)*(Sheet2!$E$1:$E$100=Sheet1!$E1)*(Sheet2!$F$1:$F$100=Sheet1!$F1),0),COLUMN(A1))