Vlookup two Excel files


Can someone advise how can I vlookup data from one excel table into another as it is shown in the picture?

Hi ,

You an try this in Lookup activity in Uipath or using Linq to compare the Datatables.


Try this video tutorial:

hi @Apple1 try using Essilor.ExcelLookup.Activities.
excel lookup

1 Like

Hi @Steven_McKeering,

I saw this video and created my process following instruction of @ [AndersJensen]
But I need rows from my second excel file: File2.xlsx to be written in a new column of File1.xlsx
In the video @ [AndersJensen] place results of Match to new Sheet3.
My target is in picture:
How can I do it?