I am trying to reference a column from another table, where this column depends on the value of the row in the current table
Basically something like that.
At the moment I have succeeded with numerous switchif cases but this is becoming unmanageable as the table expands:
It also means I need to edit the formula each time a new row is added to the table.
Is there any neat way to do all that in one go?