Vlookup activity usage


#1

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


#2

Hi All,
Am I write that it should be like this:


#3

It should be like
“Path[File.xlsx]Sheetname”

@Aggi


#4

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.