Hi, it would be nice to have the ability to choose the column based on the index so when the column changes its name, you can refer back again.
Something like this:
=LOOKUP([_THISROW].[id], “Investment Return”, “Id”, INDEX(GETALLCOLUMNS(“Investment Return”),1))