Forum Discussion

ydtau's avatar
ydtau
Copper Contributor
Dec 20, 2023

XLOOKUP disappeared

I have Excel for Mac version 16.80 (23121017) under Microsoft 365 Subscription, license provided by my university. I remember using XLOOKUP before, but it's been a few months since I've opened an excel file. Now it seems to be gone (had `_xlfn` prefix in a file with it, removing it results in NAME ERROR, and XLOOKUP is not suggested in the formula dropdown list).

 

Where did it go? Shouldn't it be available to me on this Excel version?

 

P.S. Same with SEQUENCE now I see.

 

P.P.S. These function are shown in the Excel Help window, making this even more annoying somehow.

excel
Excel on Mac
office 365
  • ydtau's avatar
    ydtau
    Copper Contributor
    Dec 20, 2023
    Problem solved!

    For posterity, what happened was that after I recently changed my university password, I had to log in again in Excel. But Excel "remembered" that I don't have a 365 subscription so the functions remained unavailable. Closing and opening the file was not enough - I had to close Excel and reopen for it to register that I should be able to access these functions.

    I hope this doesn't waste anybody else's time until it is fixed.

Resources