Excel file1 lookup file2 where file2 has shorter values

[c.ciprian (Ciprian Constantinescu)]

The macro is very simple. For UiPath you need to use Invoke VBA activity in order to use the macro, but first of all you need the formulas.
Check this post as it relates to both your needs

Fastest way to write an excel formula into an entire column

Hello everyone, Is the Write Value activity the fastest way to write formulas in Excel sheets? I’m asking you this because as far as I know when we are using this activity, we need to iterate between the excel rows in order to fulfill each row with the proper Excel formula, which means that it takes some time if the excel sheet contains too many rows (an average of 1 second per row, to write a new formula on a specific column). If I use the Write Range activity, is there a way to accept f…