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...
Can't explain that. It shouldn't. Can you share/upload the files that replicate the problem? So an Excel file and the file it connects to, with all the queries as you have them. Otherwise, I can not do anything for you. Perhaps someone else.
I can't believe it, I just did it on the desktop version and I worked fine. It's an issue exclusive to the web version it seems. I prefer the desktop version myself but a lot of my team is the opposite of techy and they prefer the web version so I create most shared docuements in the web version to make sure it works for them.
I could cry over how much time I've wasted and that's all it was...