Forum Discussion
Can't find a way to absolute reference a column name.
So I'm making a table that will give me the value from another table on a different sheet, this sheet constantly gets updated and the column order are always different so I need to use a table name. ...
=XLOOKUP($A2,Live[[Code]:[Code]],Live[Data SNG])This works in my sample file. However i wouldn't use $A2 but a structured reference if i worked in a dynamic table.
=XLOOKUP(Tabelle4[@[Entitiy]:[Entitiy]],Live[[Code]:[Code]],Live[Data SNG])