Forum Discussion

mmirfan's avatar
mmirfan
Copper Contributor
Jan 28, 2020
Solved

xlookup function not available

I am currently using office 365 latest version of MS excel 2019. but i could not find xlookup function in t
Formulas and Functions
JKPieterse's avatar
JKPieterse
Silver Contributor
Jan 28, 2020

mmirfan  Excel 2019 is NOT part of Office 365. Can you open Excel and go to File, Account page, what does it say under the Office logo?

Vanhothi's avatar
Vanhothi
Copper Contributor
Feb 05, 2020

JKPieterse My office already updated but i can use . Can you help me?Xlookup

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Feb 05, 2020
    XLOOKUP is not yet available on your channel, you'll have to be patient for about 6 months I'm afraid.
    • pstephen's avatar
      pstephen
      Copper Contributor
      Dec 17, 2020

      JKPieterse I created a spreadsheet that uses XLOOKUP...it was working perfectly.  A few days later I launch the same spreadsheet and XLOOKUP is no longer available...does this sound right?

Resources