Find a variable in an excel

I have a string variable “Angel torres”
and I have to go to an excel and look for that name and if it’s the same, bring me column “B” in this case “55100”
How can this be done?


Hi @Ivan_torres_oliva,

You can read excel to data table and use Lookup activity for cellvalue.

Hola !

Using read range activity, your output will be a Datatable, then you can read every row with Foreach row, inside that you can put a if condition and get the data that you are looking for.

Try that !

Hello @Ivan_torres_oliva, Please find attachment and try (29.8 KB)


thanks friend with your example I understood better and it works well

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