Comparing values from different sheets

Closed
Report
-
Hello,

I want to Compare Values from 2 different sheets and if duplicate. I am thinking of values on Column A & B of sheet1 to columns D & E of sheet2, if duplicate then Yes would appear on the Sheet2 Column F. and for the duplicate, if duplicate values are found in Sheet2 only duplicate would appear on the F Column of Sheet 2.