How to use vlookup for two different excel file?

[lrtetala (Lakshman Reddy)]

@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)"

Excel1:(Input)

Excel2:(Input)

Excel1:(Output)

Cheers!!