V lookup in uipath

Hii everyone I want to put the vlookup in my excel sheets I have 2 excel sheets on which I want to put the vlookup is there is any activity in uipath to to this?

1 Like


You may use execute macro activity, write a macro for V lookup in excel.

But the client told us to not to use macro activity I have to make the v lookup by own

Yah that’s absolutely possible as we got an activity for this to handle
For more details on this

The steps involved will be like
—use excel application scope and pass the file path of first as input
—now use a read range activity and get them output with a variable of type datatable named dt1
—now use another excel application scope and password the file path of second excel as input
—Inside this scope use a read range activity and get the output with a variable of type datatable named dt2
—now use a for each row loop and pass the datatable dt1 as input
—Inside the loop use a lookup datatable activity
—in the lookup datatable activity include these properties
—input datatable as dt2
—input value as row(“yourcolumnnamein dt1”).ToString
—in the lookup column mention the any one of the column name from datatable, from where we need to lookup a value
—now In the TARGET column property mention either name or column index (usually starts from 0 for first column) from dt2 which will give us the value for the lookup column we have chosen

—finally get the output value from CellValue property with a string variable

Hope this would help you

Cheers @Chetan1


Hope these steps could you

Cheers @Chetan1


Does it work faster than having a for each to search in the datatable?

Even the above steps has a for each row and of course it would

Cheers @c.ciprian