Share via

XLOOKUP available when using Excel online but not the application - help

Anonymous
2020-02-04T12:50:04+00:00

Hi,

So when I use Excel Version 1902 (Build 11328.20492) I cannot use XLOOKUP, however when I open Office 365 in Chrome, XLOOKUP is available. 

Why is this? I have checked for Office Updates through File -> Account -> Office Updates to no avail.

Please help,

Paul

Microsoft 365 and Office | Excel | For home | Windows

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
2020-02-04T14:12:10+00:00

Hi Paul,

Thank you for your message in this forum.

According to your description, it seems that you cannot use XLOOKUP feature in Excel client.

If so, we have tested it on our side and we cannot reproduce the same situation as yours. Given this situation, we’d give you some suggestions below and hope that will help you.

1.       You mentioned “I have checked for Office Updates through File -> Account -> Office Updates to no avail”, does it mean that you have updated your Excel but it didn’t work? If so, please refer to this article: Update history for Office 365 ProPlus (listed by date) to check if you have the latest version of Excel, if not, you can update your Excel to the latest version to check if the same problem will occur.

2.       Hold Ctrl key to launch Excel in safe mode, this can narrow down whether there’s any third-party add-ins affecting that. If the issue disappears in the safe mode, you may need to manually disable all add-ins then add them 1 by 1 to narrow down which is the one affecting that.

3.       If the suggestions above don’t work, you can refer to this article: Repair an Office application to repair your Office.

If the problem still persists after trying suggestions above, could you provide the information below?

1.       Could you provide the Product Information and Version of your Excel? You can go to Excel > File > Account and provide the full screenshot of Product Information.

2.       May I know if all files have the same problem? You can create a new file to check if the same problem will occur.

3.       May I know if you encountered any error message? If so, could you provide the screenshot of it?

Best Regards,

Sukie

Was this answer helpful?

0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-05-01T01:57:15+00:00

    To use XLOOKUP and XMATCH in the Excel application (as opposed to via the browser version), you must be using Office 365 and be on the Monthly Update channel, see my screen capture below. When you go to Account, what does yours say? If it says Semi-Annual Channel, you will not get it until after July 1st, as that is when they will start rolling it out to that channel.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-05-01T14:46:04+00:00

    Hi,

    I have the same issue, I've recently migrated to a new laptop and installed the latest updates so now on:

    Version 2004, build 12730.20236 but I can't use XLOOKUP on my desktop but it is available online.

    It is on the monthly channel.

    I've now got a lot of 'broken' spreadsheets that won't work, please can you suggest steps for me to get XLOOKUP onto my laptop?

    Regards

    Tim

    The only thing I can think of is that you are not using Office 365 (except I assume this "channel" stuff is only related to Office 365?)? Your version number is different from mine. As I understand it has been available to the monthly channel since about January, at least.

    Does your "account information" look like this?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-04-30T23:05:45+00:00

    Hi,

    So when I use Excel Version 1902 (Build 11328.20492) I cannot use XLOOKUP, however when I open Office 365 in Chrome, XLOOKUP is available. 

    Why is this? I have checked for Office Updates through File -> Account -> Office Updates to no avail.

    I did avail suggested Repair Option but all in vain. I still cant avail new Functions like XVLOOK and Unique etc.

    Please help,

    Nafees

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-07T16:00:56+00:00

    Hi Paul,

    May I know if you have seen my reply? May I know if you still need help? If so, you can post back and we will continue to help you.

    Best Regards,

    Sukie

    Was this answer helpful?

    0 comments