# Comparison of runtime parameter with excel values

**URL:** <https://community.automationedge.com/t/comparison-of-runtime-parameter-with-excel-values/2448>\
**Category:** Get Help & Discuss\
**Created:** [August 6, 2020, 6:05am UTC](https://community.automationedge.com/t/comparison-of-runtime-parameter-with-excel-values/2448 "2020-08-06T06:05:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sonam](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@sonam](https://community.automationedge.com/u/sonam)\
**Post date:** [August 6, 2020, 6:05am UTC](https://community.automationedge.com/t/comparison-of-runtime-parameter-with-excel-values/2448/1 "2020-08-06T06:05:18Z")

</div>

I have created 1 workflow in which I want to pass the value during runtime and that value should be compared with all the values of the excel sheet or with particular column of excel sheet. How can this be achieved in PS.

---

<div class="post-metadata">

**Author:** ![rohini.deshpande](https://avatars.discourse-cdn.com/v4/letter/r/e79b87/32.png) [@rohini.deshpande](https://community.automationedge.com/u/rohini.deshpande)\
**Post date:** [August 6, 2020, 12:14pm UTC](https://community.automationedge.com/t/comparison-of-runtime-parameter-with-excel-values/2448/2 "2020-08-06T12:14:46Z")

</div>

Hi Sonam,

As shown in below images, you can use get variable or generate rows step in that workflow to get those run time values(to convert variables in fields).  
After that you can join/lookup those values in excel file fields and then proceed with the next activities.  
 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/f7019d0c0492ed75a828de90a6b4c893ac4d82d8.png) **or**![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/21e95480c39ada4223c2a2b6ee55a5e5e90c3605.png)

---

<div class="post-metadata">

**Author:** ![sonam](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@sonam](https://community.automationedge.com/u/sonam)\
**Post date:** [August 6, 2020, 1:02pm UTC](https://community.automationedge.com/t/comparison-of-runtime-parameter-with-excel-values/2448/3 "2020-08-06T13:02:05Z")

</div>

Hi Rohini,

Thanks for the reply.I tried implementing the above steps in my workflow and its working as expected.