Can I get some table on condition?

[Kang1]

Hello everyone.

I want to bring up the row-key value of table with column value.

But I think table can be several.

So, I can’t use ‘Table[Column]’ formula.

This is an example that i want to make it.
ifs(
isnotblank([_thisrow].[LinkToRowName]),
LinktoRow(???, [_thisrow].[LinkToRowName])
)

I don’t know the proper formula.
Plz help me,

[Kirk_Masden]

Hi! Welcome to the forum!

I’m in Japan so, if you are in Korea, we’re not very far away.

At any rate, I’m having a little trouble understanding your question. Keys are for rows, not tables. Do you mean that your want to find the key for a row in another table that has the same value as a row in this table? That can be done with the FILTER() expression:

help.appsheet.com

FILTER()

Select rows of table or slice

[Kang1]

Hello!

Umm… I want to set the table to change according to the conditions, and the column to what the tables have in common.

And by setting tables as variables, you always want to bring your own table column even if multiple tables are applied, not one table depending on the conditions.

My explanation is so chaotic.
If it’s not enough, I’ll organize it more and answer it.

[Kirk_Masden]

Thanks for your response. I’m still having some trouble understanding. But if you want to find the key values of rows with common values, I think that you will probably want to use the FILTER() expression, or perhaps the SELECT() expression.

Perhaps someone else can help us.

[Rafael_ANEIC-PY]

Hello @Kang, I don’t understand exactly what is it that you need, maybe if you filled some dummy data on a sheet we would be able to see what you want to achieve?