Excel-loop (three variables are in one row)

Good day! I have an Excel table for 10 columns and several thousand rows and 3 variables (String). The task is to check the table for the content of these variables.
But а task is considered completed if all three variables are in one row.
Help me please.
Thank you in advance.

Hi @Nataliya_Zotkina,

I can recommend you to use If-else condition.
First, you should put Excel content to a table variable using “Get Range” action.
Then add “For Each” row action. So it will check each row if it contains variables.
And finally, use “If-else” condition inside the If-Else condition. Here’s an example:

In this example the bot checks if a row contains string variable “string_1”, if it does, then it checks if it contains string variable “string_2” etc. If it contains all variables then it opens “notepad”. If not it enters “Win+R” combination.

Hope that helps!

2 Likes

Thank you for help!
It works!

1 Like

Glad it helped @Nataliya_Zotkina !
Thanks for confirmation:)