Find a variable in an excel

Help
, , ,
1

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?

image

2

Hi @Ivan_torres_oliva,

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

image
image842×443 20.5 KB

3

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 !

4

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

2 Likes
5

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

6

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