VLOOKUP for every row in different excel files

Help Studio
1

Hi Guys,

Need some help in my automation project. I am trying to do VLOOKUP in different workbook.
I have a two excel files. One is the report (excel A) and master data (excel B). I am try to find data for excel A from excel B. Let me give you example.

image
Excel A

image
Excel B

image
Expected Result

Thanks in advance. :innocent:

x

2

Hi,

There are some ways to achieve it. One of them is to use JoinDataTable activity as the following, for example.

img20220405-1
img20220405-11019×1145 29.9 KB

Sample20220405-1.zip (10.3 KB)

Hope this helps you.

Regards,

3

Thanks for reply.

Sometimes the column is different. Are any way to find the data by using VLOOKUP?