Find value in different table without link

Let suppose I have table"Perf" with a calculated column “word” (ABC,AAA, BBB, BAC, …)
In another table “Result” I have 2 columns:
One "value’ with all possibilities ABC,AAA,AAB,AAC,…
One “result” with the arbitrary corresponding value (A,B,C,…)

How can I ask Perf.word column to look for corresponding Result.value and return Result.result

There is no link between those table

Use data processing - “lookup and copy” should be the right operation:

Hi thanks

It seems data processing does not work with calculated column. Can you confirm ?


In this case, you need to use “auto add link”

Tested Ok thanks :+1:

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