Forum Discussion
Xlookup shifts if I add a column to the query
I have a query table that I'm referencing using an xlookup function on another table. When I add a column to the query, any xlookup gets shifted over one column. =XLOOKUP ("Value", Querytable[Column...
Most probably "Preserve column sort/filter/layout" is unchecked in your case (right click menu -> Table -> External data properties)
Usually it's checked by default. Try to check this property and see repeat inserting column again.