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...
If one of the documents the query is pulling data from gets an extra column or if a column that was previously removed in a query step but then is changed so it’s no longer removed, both result in all xlookup functions to the right of the new column get misaligned.