How to work with VLOOKUP in UiPath

Hi Everyone,
would anyone please let me know how can we do vlookup.
I have 2 excel files in a folder. file-1 and file-2
Have to compare the columns of “Transaction details” and “Amount” in file 1 with the columns of “Phone Numbers” and “Amount” in file 2
If matches with the phone number and amount, in file-1 need to create a column as “OK/NOT_OK” and print OK if matches otherwise NOT_OK.

Is it possible by using UiPath?

Thank you so much in advance.

Regards
Vishnu
File1.xlsx (12.4 KB)
File2.xlsx (32.5 KB)

A post was merged into an existing topic: Excel Data Manipulation Advice