Forum Discussion

Silv's avatar
Silv
Copper Contributor
May 10, 2025

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.

 

I used xlookup to lookup the code I have on column A on the table below and give me the values on their specific column,
I was able to make column C work by making A2 absolutethis is the "Live" tableMy problem now is, if I drag them to the right, my lookup array gets moved to the right

Is there a way to make D2 and everything on the right show with the lookup array absolute if I drag them to the right?

D2 should give me "SET {SET}" with below:

=XLOOKUP($A2,Live[Code],Live[Unit_SNG])

 

Thank you!

excel
Formulas and Functions
office 365
training

1 Reply

Sort By
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    May 12, 2025
    =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])

     

Resources