Excel Formula: Compare Column A and B in Sheet1 and Sheet2, If matches copy Column C and Column D data from Sheet1 to Sheet 2

Compare Sheet1.Column A with Sheet2.Column A, If matches then compare Sheet1.Column B with Sheet2.Column B. If matches copy Sheet1.Column C and Sheet1.Column D data to Sheet2.Column E and Sheet2.Column G.

Sheet1




Sheet2


Result


Formula: 
=IF(AND(COUNTIF(Sheet2!A2,Sheet1!A2),(COUNTIF(Sheet2!B2,Sheet1!B2))),Sheet1!C2,0)