Compare 2 work sheets and return YES or NO

Hi Need a help,
Apply Vlook between sheet 1 and Sheet 2
compare col J in both sheets
If there is matching record, enter "yes" in column X(Flag) of Sheet1. If not matching , enter "No"

If you compare column J in both sheets you will get a 'No' in every row as column J contains very different data between the two sheets.
Also, 'Flag' in your example workbook is column V not X as stated. However, if you enter the below formula in V2 on Sheet1 and copy down you will get your desired outcome:

Formula:

Please Login or Register  to view this content.

BSB

Please take a look at your sheets, because there is no fair comparison between column J in both sheets. Maybe you mean column I in Sheet1 and column K in Sheet2. Also, the flag is in column V instead of X. It sounds like you just want an =IF(ISERROR(VLOOKUP())) formula. It will look something like this (but you will need to correct the columns): =IF(ISERROR(VLOOKUP(J2,Sheet2!$J:$J,1,0)),"No","Yes")

You would put this formula (with corrected column references) in cell V2 and then paste it down.