Excel-Mapping of Data

[PAD]

You may also check the solution from the thread below:

Excel Vlookup Using UiPAth

Hi, I wold like to perform vlookup using UiPath, I have a excel file in that I have 2 Sheets (Sheet1 and Sheet2) in both the Sheet I have a common column (userId) with unique value, I want to do a lookup in Sheet one which tell me the common userId in both sheet, I have attached the screenshot of my excel file for reference. [Vlookup] How can we do this in UiPath. Thank You!!!.

You would just replace the selector and the formula with the relevant one, like =VLOOKUP(A2,‘[MasterSheet.xlsx]Sheet1’!1:1048576,2,FALSE)