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...
Whatever. I never use Excel for the web. It's just not the same as real Excel. Still too many quirks for my taste. Even though it's getting better all the time.