VLOOKUP in 2 Excel sheets/Datatables

Help Activities
, ,
1

Hi all.
I’m trying to follow a process done in Excel and automate it in UiPath.
I need to perform a VLOOKUP in a new column, the first column in Excel.
the following was typed in A2 and then dragged down to the entire column:
=VLOOKUP(B2,[pieces.xlsx]Pieces.!$A:$B,2,False)
note that “pieces” is the second workbook.

Can anyone solve this and advise how to perform the above?
Thank you!

2

Hi @hp321

If possible can you share the excel file.

Regards,

3

@hp321

if pieces.xlsx is a different workbook then you need to provide the full path of the workbook

"=VLOOKUP(B2,'C:\users\path\[pieces.xlsx]Pieces'!$A:$B,2,False)"

cheers