🔥 Subscribe for uipath tutorial videos

: Vlookup in Uipath or Vlookup using Uipath between Two Excel Files. In this video of excel automation chapter 5, we will learn how to implement the vlookup function in uipath. For vlookup in uipath we will be using lookup datatable activity. First we will see the demo on how to use the lookup datatable and based on this we will create the logic for Vlookup.

Vlookup is a most needed activity when it comes to excel automation. In this example we are taking two sample excel files. In both the excel files the primary key value is the customer id number. Using customer id number we are going to perform the vlookup action.

In this youtube tutorial video of vlookup using uipath, you will find an interesting of utilising the datatables in the vlookup properties panel. Once we know how to utilise the properties panel in vlookup activity it becomes quite easy to master it.

Getting the vlookup uipath output may sound easy, however writing that to excel file in the particular…

UiPath.Core.Activities.LookupDataTable This activity enables you to search for a provided value in a specified DataTable and returns the RowIndex at which it was found. If the provided value is not found, then the returned RowIndex is -1. This activity can also help you return the value found in the...