Vlookup two Excel files

Learn Academy Feedback
#1

Hi,

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

#2

Hi ,

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

Compare Excel/Lookup Data Table without getting same value
#3

Hello

Try this video tutorial:

#4

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

1 Like
#5

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:
Vlookup_result
How can I do it?