LookUp Range

お世話になります。

LookUp Rangeでexcelファイルを検索し、その結果を変数lookup(string型)に格納します。
そのセルがC5とするとき、A5の情報を読み取ってかきこみたいのですが、どうしたらよいでしょうか?

よろしくお願いします。

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:
Regards,
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,

Regards,
Pavan H