Hi,
I have two excel files , in the first one there are some document no’s which i need to pickup one by one & find them in the other excel, if a match is found then I need to log it.
The problem is that the doc no’s in the first excel can get repeated any number of times and if a match is found then it should continue to pickup the next record, although there can be a possibility that the next record can be the same doc no as the above, refer to the screenshot below :
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/e3a3af04-045a-43ee-b15e-c09888a63b14.png)
So according to the above image, the bot should pickup the first record (14669), if match is found then it should ignore the rest of the 3 records and pickup the next record.
How can this be achieved? Any help would be appreciated :)