Extract excel informative

Hello I have a excel sheet where i have 3 columns.
I have 3 variables and want to perform the following.

I want to look up in that datatable and check column 1 and 2 if those columns match my two variables then retrieve information from column 3 and assign it to variable.

Like this:

Processusvierge.zip (14,0 Ko)

Thanks, but in the assign activity should it not be var3 = row(2) ? right now i am assigning my variable to the column 3, but want to extract the information from column3 and pass it to my variable

In that case, yes. Reverse the left and right-hand sides of that assign activity and it’ll work.

But set Row(2) to Row(2).ToString, just in case there is a datatype problem.

1 Like

Thanks !

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.