How to do vlook up in two different excel without opening it

Anyone know’s how to do it. I need the solution of this on urgent basis.

ExcelVlookUp.xaml (16.5 KB)
vLookUp.xlsx (9.4 KB)
vLookUp_1.xlsx (9.4 KB)

Please find attached solution.

@syrajkumar - I don’t know why it is not working. It is able to run successfully but not printing anything on output.

DataTable2.AsEnumerable().
Where(function(row) Not DataTable1.
AsEnumerable().
Select(function(r) r.
Field(Of String)(“Name”)).
Any(function(x) x = row.Field(Of String)(“Name”))).
CopyToDataTable()

Can you check your workBookPath.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.