Compare 2 excel Files for order no and marchent ID if match to take Store Code

hi
i have 2 excel files.
i have to compare from Excel-2 OrderNo to in Excel-1 Merchant_ID if it matched have to take Store Code from Excel-2 then write in Excle-1 in Store Code Column.if not matched write in store code column --N/A

Excel-2


Excel-1

Can any one help it ?

Excel-1.xlsx (10.8 KB)
Excel-2.xlsx (9.9 KB)

Hi @Anand_Designer,

This can be done within Excel, please see the attched link:

Regards,
JM

in Uipath ?