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)
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!!