Forum Discussion

uchidozie's avatar
uchidozie
Tin Contributor
Aug 02, 2026

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...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 02, 2026

uchidozie​ 

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.

  • uchidozie's avatar
    uchidozie
    Tin Contributor
    Aug 02, 2026

    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...

  • uchidozie's avatar
    uchidozie
    Tin Contributor
    Aug 02, 2026

    Unfortunately there’s private info on them so I cannot share. This is just such a project destroying issue that I cannot believe I’m the only one who has ever experienced it.