Comparing values from different sheets

D.P. - Jul 21, 2015 at 05:19 AM

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.