LookUp Range


LookUp Rangeでexcelファイルを検索し、その結果を変数lookup(string型)に格納します。


Hi @dora,

The lookup range activity will give you the output as cell name of value that you are searching for, here you need to know the value for which you need to get the cell name.

Correct me if there is something I am missing

This is the workflow for your reference BlankProcesAI.zip (14.4 KB)

In japanese:




Sorry if I missed something in your language please blame google translator for that :smile:
Pavan H

Thank you for your reply.

Let me explain more detail about my question.

For example, what if I want to get information on C2 in the same row after looking for cell A2 with lookup range activity?

In your workflow case, you get cell A2 by lookup range activity.
What I want to know is waht should I do when I want to get cell C2?

Thank you for your help.

Hi @dora,
If you know the value present in c2 then u can get the c2 as output,
I wold suggest you to use read excel using excel application scope read range and then once you get the table use lookup datatable to get the row index of the value you are looking in that column and then, assign that to a variable and then get the cell name of that variable using lookup range activity

Let us know if this helps,

Pavan H