How to apply VLOOKUP in UIPATH

[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!!