HI, I am trying to compare two values across different sheets in excel and to automate sending of email if one value is smaller than the other. For example, I have a number in cell A1 in sheet 1 and another number in cell B2 in sheet 2. I’m looking for UiPath to help me automate sending an email …

Yes, just read the value in A1 and assign it to a variable (value1) and do the same for B2 using read range. Then define the if-condition as if: value1 < value2. Make sure that the value is of type int.

Hi Hope this thread would help you resolve this [image] Compare two data tables in different excel files Help Hey @Vamshi You can use Following linq to get what you want slight_smile Scenario is fetch the tags data from excel1 column and find in excel2 in Controller co…

Thank you. Can I confirm if the assign step is required? And should i save the variable type as data table before assigning it? Since it is only a cell value instead of a data table, I’m trying to figure out how should the assign step be filled up. Thanks! [image]

IF function (To compare excel value)

Help Studio

Palaniyappan (Palaniyappan P ) September 2, 2021, 6:33am 3

Hope this thread would help you resolve this

Cheers @victorialim

Topic		Replies	Views
IF and ASSIGN activity (to compare excel values) Activities excel , activities , question	9	1863	September 5, 2021
How to compare the value in different sheet Studio	3	934	August 16, 2020
Compare 2 column of different different excel file Studio datatable , excel , activities	7	1055	March 14, 2020
How to compare If Condition with excel values Help excel , activities	13	2807	November 29, 2019
Compare one by one cell value from 2 sheet Activities database	3	549	April 10, 2023

IF function (To compare excel value)

Related topics