Using IF with Excel source data


Hello. I have the excel file below.


And I’m creating the RPA process below, loading the raw data into a “table” type variable.


So, the question is: within a For-Each loop, how to use If-Then condition, checking if the 3rd column (Type), is equal to something?




Hi Trajano,
You need to use two For Each loops in this case:
one to get a Row
the second one to get the value in the cell in the third column as shown in the screenshot below.

Then you can compare the value in the cell with your target value.



Perfect! Thanks a lot! It works fine! Excellent solution.