# How to compare each value from both excel files

**URL:** <https://community.automationedge.com/t/how-to-compare-each-value-from-both-excel-files/3947>\
**Category:** Process Studio\
**Tags:** rpa\
**Created:** [July 20, 2021, 3:01pm UTC](https://community.automationedge.com/t/how-to-compare-each-value-from-both-excel-files/3947 "2021-07-20T15:01:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bhanutejadeegoju](https://avatars.discourse-cdn.com/v4/letter/b/58f4c7/32.png) [@bhanutejadeegoju](https://community.automationedge.com/u/bhanutejadeegoju)\
**Post date:** [July 20, 2021, 3:01pm UTC](https://community.automationedge.com/t/how-to-compare-each-value-from-both-excel-files/3947/1 "2021-07-20T15:01:30Z")

</div>

I want to compare each value of row to the each value of column from different files.  
 ![Screenshot (7)](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/f67c0bb40157b382c45c9a72593479f1e0d0f389.png)

 ![Screenshot (9)](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/b7d03370565c3815a78a075e8318cbfd9bcfdfde.png)

I have also attached the screenshot of dummy files, in which I want to fetch the rule for each IP address where Error is occurred.  
Here I want to fetch commands from master file where ever the Error is present in input file of that particular Rule.

Kindly help me with this scenario.

---

<div class="post-metadata">

**Author:** ![aditya.devi](https://avatars.discourse-cdn.com/v4/letter/a/e47774/32.png) [@aditya.devi](https://community.automationedge.com/u/aditya.devi)\
**Post date:** [July 22, 2021, 10:49am UTC](https://community.automationedge.com/t/how-to-compare-each-value-from-both-excel-files/3947/2 "2021-07-22T10:49:32Z")

</div>

[Excel Operations.zip](https://community.automationedge.com/uploads/short-url/rfAqueYhKZvaYbAffcuRs1bi68T.zip) (20.2 KB)

 ![RowND](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/be0bdc1af540f9f879a1cacd3a2baacd001708c1.png)  
Please refer attached process studio project and screenshot.

---

<div class="post-metadata">

**Author:** ![bhanutejadeegoju](https://avatars.discourse-cdn.com/v4/letter/b/58f4c7/32.png) [@bhanutejadeegoju](https://community.automationedge.com/u/bhanutejadeegoju)\
**Post date:** [July 22, 2021, 12:05pm UTC](https://community.automationedge.com/t/how-to-compare-each-value-from-both-excel-files/3947/3 "2021-07-22T12:05:03Z")

</div>

Thank you for this reply. This could be very helpful.