Vlookup 20+ columns from various sheets

Help Activities
, ,
1

Hi all,

I have 5 excel files having multiple columns (20+) to be looked up based on key.

How it can be done.

Any suggestions will be of great help.

Regards,
Ayushi

2

can you give us sample input and output

3

Hi @_Ayushi_Jain ,

Use UiPath’s Excel activities: UiPath has a number of activities that allow you to work with Excel files directly from your workflow. You could use the Read Range activity to read in the data from each of your Excel files, and then use the Filter DataTable activity to filter the data based on the key value. You could then use the Output DataTable activity to write the filtered data to a new Excel file or output it in another format.