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)
No comments:
Post a Comment