Im trying to do a Vlookup of two excel files

[sathish_moorthy]

Im having two excel files ,I need to compare “Document Number” column with the two files .If it matches then I need to copy the values from column “Success/Error” and “Fiscal Year” from the second file and update it in the first file(columns name will the same in both files".I have attached sample files.
forum1.xlsx (9.2 KB)
Forum2.xlsx (9.3 KB)

[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

[mkankatala (Mahesh Kankatala)]

Hi @sathish_moorthy

You can use the Vb code to Vlookup between two files,
→ Use Read range workbook activity to read the excel File1 and store in a datatable variable.
→ Use another Read range workbook activity to read the excel File2 and toer in other datatable variable.
→ Then use the Invoke code activity and write the code.
→ Then use the write range workbook activity to write the output data to excel File1.

Check the below workflow for better understanding,
Sequence26.xaml (9.4 KB)

Hope it helps!!