Hi All,

I have two excel Files.

In First excel file i have “SET” column and the data to be filled in it by using vlookup formula.

Vlookup Formula usages data from second file…

How can i use use Uipath vlookup activity for this…

Thanks in advance

Hi All,

I have two excel Files.

In First excel file i have “SET” column and the data to be filled in it by using vlookup formula.

Vlookup Formula usages data from second file…

How can i use use Uipath vlookup activity for this…

Thanks in advance

Dear SagarSB,

Thank you for correction! It is work for me for 1 column.

In my task I have one file with 3 sheets. I check how table B(sheetname- B) corresponds to table A (sheetname- A). Then I want to write all answer into the sheetname C.

If I want for each column (I have 5 in the table) should I use each activity? Because how to get next column index I (I hope) know. Instead of zero I have “i” and Assign i=i+1, where i<=CoumnCount.

But how to write different ValueToLookup (for each column will be different). Sorry if this question looks like very naive, but I am junior in this field and I will grateful for the clarifications.