Forum Discussion

Bsct23's avatar
Bsct23
Copper Contributor
Jul 01, 2021

XLOOKUP on a Mac

Hello,   My question regards XLOOKUP not running in Excel on a Mac. I use Office 365 in French. On microsoft.com, they say that XLOOKUP should 'generally' be available on a Mac: https://www.micro...
Excel on Mac
Bsct23's avatar
Bsct23
Copper Contributor
Jul 01, 2021
Riny_van_Eekelen mtarler
I rebooted my Mac and it fixed the issue.
I hadn't not done it yet since installing Microsoft 365 the day before yesterday..
Good to remember…
Many thanks for your quick reactions!
EdgarTovar's avatar
EdgarTovar
Copper Contributor
Sep 02, 2021

Bsct23 I have exactly the same problem you had, I'm on Microsoft® Excel for Mac Version16.52 (21080801), and the XlookUp function doesn't work at all 😕 Any suggestion? 

  • Vijay9595's avatar
    Vijay9595
    Copper Contributor
    Mar 29, 2023
    I'm running 16.7 and i have the same issue.
    • sikkingj's avatar
      sikkingj
      Copper Contributor
      Apr 30, 2023

      Vijay9595 

       

      Using version 16.72 - still no XLOOKUP.  I'm assuming this function will never be added?

      • TravisKruger12345's avatar
        TravisKruger12345
        Copper Contributor
        Nov 07, 2023

        sikkingj 

         

        Makes no sense...yesterday I was using this function successfully on my mac...updated to latest Mac Sierra update last night and now xlookup isn't working....very frustrating.

         

        Assuming we need a new update from Microsoft to come through first. Ridiculous...how can they remove functionality that was previously there?

Resources