Im trying to do a Vlookup of two excel files

[ashokkarale]

@sathish_moorthy,

Kindly refer these threads,

Vlookup with Two Excel Files using LINQ

find starter help here: UpdateDTLeft_1ColLookup_DictRixSet.xaml (11.1 KB)

How to use vlookup for two different excel file?

@suraj_gaikwad You can pass the file name dynamically in a variable like below FileName="Excel2.xlsx" "=VLOOKUP(B2,[" + FileName + "]Sheet1!$B:$B,1,0)" [image] Excel1:(Input) [image] Excel2:(Input) [image] Excel1:(Output) [image] Cheers!!

Still faces any issue, let us know.

Thanks,
Ashok