I am having 2 excel file. In Excel 1 I have (Vend Material Number Vend Id) Columns.
In Excel 2 I have (Vend Id), If vend id in excel 2 matches with excel1 Get the material number from Excel 1 and update in Excel 2.
Excel 1 :
Excel 2: (Required Output)
There are more than 10k rows, I need to find match & update without using Loop.
Kindly, suggest some solution for this.
Thanks in advance.