Select column based on column index

[Daniel_Panero]

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))

[LeventK]

In terms of data design, dependency and RDBMS, column headers or column names cannot be dynamic. Therefore what you request is a bit out of data logic.