Why do I not have xmatch or xlookup?

Anonymous
2021-02-07T09:22:04+00:00

I have a Microsoft 365 Family licence and I am running Excel on my iMac.

I cannot work out why I do not have the new functions that should be available, the two I've tried to use are xmatch and xlookup, the Microsoft support pages indicate they should be available.

I have just downloaded and reinstalled Office to my iMac. It installed 16.47 (21020100).

I then switched to the Beta Channel and it installed 16.47 (21020300).

Is there something different between 365 licences?

Thank you for your help.

Microsoft 365 Insider | Excel | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2021-02-10T12:44:34+00:00

I have resolved by running the Microsoft Office removal tool on my mac and reinstalling, it then asked which license I wanted to use.

I am now running 365 Subscription :-)

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-02-10T12:03:11+00:00

    Hello

    So I know the root cause, I just do not know how to fix it.

    I have two subscriptions in my Microsoft Account.

    1. Microsoft 365 Family
    2. Office Home & Business 2019

    I have proven that despite uninstalling and reinstalling Office it is still using my 2019 Retail Licence and not my 365 Subscription.  Another user with their own Mac sharing our 365 Family license has a 365 Subscription so I know it works.

    Any help or insight as to how to fix this issue would be greatly apprecaited.

    Thank you for your help.

    Was this answer helpful?

    0 comments