How to apply VLOOKUP in UIPATH

[T_Y_Raju]

how can we apply vlook up in excel in 2 different sheets

can any one show me an example of vlook up how it can be done in UiPath

[ashokkarale]

@T_Y_Raju,

Refer these threads,

Vlookup column from one excel file into another

Hi @Apple1 kindly find the attached workflow for reference: Lookup_Case.zip (366.7 KB) Mark it as solution if u got it Regards Nived N Happy Automation

Need to run VLOOKUP using two different workbooks

Hello! I have two Excel sheets, a.xlsx and b.xlsx, where a contains column A (unique IDs), and b contains columns E (unique IDs that match column A in a.xlsx, but may not be in the same order as they are in a), and F (the demand for the IDs in dollars). The VLOOKUP formula is set up in a blank column of a.xlsx (let’s say column E), and here are the parameters passed in the VLOOKUP formula when doing it manually in column E of sheet 1 in workbook a.xlsx: VLOOKUP(A2’[b.xlsx]Sheet1’!$E:$F,2,FALS…

Vlookup between two different excel file sheets

Hello everyone, I am facing some issues while applying vlookup between two excel file sheets using the lookup datatable activity in uipath. Can anyone please provide help for how to properly apply Vlookup or lookup datatable between two different sheets of different files for eg. say sheet “abc” of xlsx file 1 and sheet “def” of xlsx file 2. Thankyou

Need to Vlookup Two Excel With VBA Code & invoke in Uipath

Hi @Balaharish_T , Sub VLOOKUP_Between_Excel_Files() Dim wb1 As Workbook, wb2 As Workbook Dim ws1 As Worksheet, ws2 As Worksheet Dim lastRow1 As Long, lastRow2 As Long Dim i As Long, j As Long Dim lookupValue As Variant, result As Variant ' Open both workbooks Set wb1 = Workbooks.Open("Path_to_Excel_1.xlsx") ' Replace with your file path Set wb2 = Workbooks.Open("Path_to_Excel_2.xlsx") ' Replace with your file path ' Set worksheets Set ws1 = wb1…

Thanks,
Ashok

[lrtetala (Lakshman Reddy)]

Hi @T_Y_Raju

@T_Y_Raju

show me an example of vlook up

"=VLOOKUP(B2,Sheet1!B:E,4,0)"

Input:(Sheet1)

Input:(Sheet2)

Output:(Sheet2)

How to use vlookup for two different excel file?

@suraj_gaikwad You can pass the file name dynamically in a variable like below FileName="Excel2.xlsx" "=VLOOKUP(B2,[" + FileName + "]Sheet1!$B:$B,1,0)" [image] Excel1:(Input) [image] Excel2:(Input) [image] Excel1:(Output) [image] Cheers!!

UiPath Excel Lookup | How to Use UiPath Excel Lookup Activity

Activities - VLookup

Cheers!!