Compare 2 excel files row item and paste in 3rd excel file

[Anil_G (Anil Gorthi)]

Duplicate

Compare Two excel and paste the 2nd excel matched data in 3rd excel

@Shivam_Rana Please check this dt2.AsEnumerable.Where(function(x) dt1.AsEnumerable.Where(function(y) y("Name").ToString.Contains(x("Name").ToString) AndAlso y("City").ToString.Contains(x("City").ToString)).Count>0).CopyToDataTable This compared if dt2 has Name and dt1 has LH_Name …if it is other way rounf then interchange x and y in the contains statement And gets the dt2 records which are matched cheers