Excel XLOOKUP function no longer works in Office 2024 Home

Question

Excel XLOOKUP function no longer works in Office 2024 Home

jeffersonj 30

I installed Office 2024 Home on Windows 11 last year. I use Excel frequently, and XLOOKUP has worked until today (6/1/2026). However, today this function throws the #NAME? error. In cells where I had previously entered this function and saved the workbook, the formula has been changed to "=_xlfn.XLOOKUP(...)" which appears to return correct result but cannot be copied down. The file is XLSX format, and window title does NOT show "compatibility mode."

I see an update to Office (16.0.20026.20112) was installed earlier today. I suspect the failed function is related. Please fix this error or provide a reasonable solution. Thank you.

ThomasJ 0 Reputation points

2026-06-02T12:49:54.7933333+00:00

Did these "fixes" fix it? I just opened my work books and found the same issue. Only difference is I am running a Macro enabled workbook.
jeffersonj 30 Reputation points

2026-06-03T14:36:06.0766667+00:00

ThomasJ - Kai-H provided me Home-specific instructions for reporting this problem to the product team. I will try to post update when I hear from them.
jeffersonj 30 Reputation points

2026-06-11T00:15:00.11+00:00

Posted the info on this issue via Help > Feedback > Report a problem (thanks, Kai-H!) June 3. No response or acknowledgement so far.
jeffersonj 30 Reputation points

2026-06-17T17:46:03.8266667+00:00

Two weeks out, there's been no response, not even an automated acknowledgement. This is not surprising, considering that only one other user has reported the problem. I think I will try to reach Microsoft Support. But I see only two viable solutions for the interim:

(1) Find out what exactly the June 1 update does, and if nothing critical, roll it back.

(2) Create a custom function to replace XLOOKUP. This should be pretty easy to do in VBA, but most likely will be monstrously slow to execute.

Answer accepted by question author

Kai-H 27,310 Microsoft External Staff Moderator

Hi, jeffersonj

Since XLOOKUP is listed for Excel 2024, this does not look like a normal workbook compatibility problem by itself. The _xlfn. prefix usually means the copy of Excel currently opening the file is not recognizing that function, so I would first treat this as an activation/account/update issue rather than rewriting the workbook.

Here are some suggestions you can try:

Open Excel and go to File > Account. Make sure it shows the expected Office 2024 Home license and that Excel is activated. If it shows a different account, expired license, or “Product deactivated,” sign out, close Excel, reopen it, and sign back in with the Microsoft account that owns Office 2024.

Try opening the same workbook in Excel for the web through OneDrive. It is recommended that if the formula works online, save a fresh copy from there, then reopen that copy in desktop Excel. This can help confirm the workbook itself is still okay.

In the desktop file, do not manually edit every formula yet. First make a copy of the workbook. After Excel recognizes XLOOKUP again, use Find and Replace to find _xlfn. and replace it with nothing. That should restore formulas like =_xlfn.XLOOKUP(...) back to =XLOOKUP(...).

If the problem started right after build 16.0.20026.20112, report it through File > Feedback > I don’t like something and include the build number. Since Office 2024 should support XLOOKUP, this may need Microsoft to correct the update if the license is already valid.

Thank you for your patience in reading, I hope this information has been helpful to you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment."

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

jeffersonj 30 Reputation points

2026-06-02T14:27:56.6033333+00:00

Thanks, Kal! I wouldn't have thought of this. But license, version, and owner all check out. I will take your last suggestion, report it as "don't like," and see what response I get. If it leads to a solution, I will accept your comment.
jeffersonj 30 Reputation points

2026-06-02T14:51:59.2466667+00:00

Kai - Sorry, what is the context for "File > Feedback > I don’t like something"? I don't see this menu on current page, any other Learn page, or in Excel.
Kai-H 27,310 Reputation points Microsoft External Staff Moderator

2026-06-03T06:29:23.3366667+00:00

Hi, jeffersonj

Here are the detailed steps for you to give feedback through the app:

On the Ribbon, you'll see the Help section

Once clicking the "Help" section, you'll see there is a "Feedback" part, click it.

There'll be a feedback panel appearing. Choose "Report a problem"

Provide details on your issue, you may attach screenshots or recording if you like, then click Submit to send your feedback.

Please note that this is a user-to-user support forum. Moderators and contributors, including external Microsoft employees, are not allowed to directly interfere with Microsoft product features or access back-end systems. Our role is limited solely to providing technical guidance on reported incidents, requests, or ideas.

Thank you for your patience and understanding

2 additional answers

Your answer

ThomasJ 0 Reputation points

2026-06-02T12:49:54.7933333+00:00

Did these "fixes" fix it? I just opened my work books and found the same issue. Only difference is I am running a Macro enabled workbook.
jeffersonj 30 Reputation points

2026-06-03T14:36:06.0766667+00:00

ThomasJ - Kai-H provided me Home-specific instructions for reporting this problem to the product team. I will try to post update when I hear from them.
jeffersonj 30 Reputation points

2026-06-11T00:15:00.11+00:00

Posted the info on this issue via Help > Feedback > Report a problem (thanks, Kai-H!) June 3. No response or acknowledgement so far.
jeffersonj 30 Reputation points

2026-06-17T17:46:03.8266667+00:00

Two weeks out, there's been no response, not even an automated acknowledgement. This is not surprising, considering that only one other user has reported the problem. I think I will try to reach Microsoft Support. But I see only two viable solutions for the interim:

(1) Find out what exactly the June 1 update does, and if nothing critical, roll it back.

(2) Create a custom function to replace XLOOKUP. This should be pretty easy to do in VBA, but most likely will be monstrously slow to execute.
jeffersonj 30 Reputation points

2026-06-02T14:27:56.6033333+00:00

Thanks, Kal! I wouldn't have thought of this. But license, version, and owner all check out. I will take your last suggestion, report it as "don't like," and see what response I get. If it leads to a solution, I will accept your comment.
jeffersonj 30 Reputation points

2026-06-02T14:51:59.2466667+00:00

Kai - Sorry, what is the context for "File > Feedback > I don’t like something"? I don't see this menu on current page, any other Learn page, or in Excel.
Kai-H 27,310 Reputation points Microsoft External Staff Moderator

2026-06-03T06:29:23.3366667+00:00

Hi, jeffersonj

Here are the detailed steps for you to give feedback through the app:

On the Ribbon, you'll see the Help section

Once clicking the "Help" section, you'll see there is a "Feedback" part, click it.

There'll be a feedback panel appearing. Choose "Report a problem"

Provide details on your issue, you may attach screenshots or recording if you like, then click Submit to send your feedback.

Please note that this is a user-to-user support forum. Moderators and contributors, including external Microsoft employees, are not allowed to directly interfere with Microsoft product features or access back-end systems. Our role is limited solely to providing technical guidance on reported incidents, requests, or ideas.

Thank you for your patience and understanding

Answer 1

jeffersonj 30

Go to File > Account. If you see a warning message that you are not signed in, click "Sign In" button and complete sign-in process. You may need to reset your settings while you're at it.

0 comments

Answer 2

jeffersonj 30

Well, surprise! While looking for specifics on updates, I had to "sign in" to my account within Excel. And suddenly XLOOKUP works fine. Causality not proven, but nothing else has changed that I know of. So I'm happy (at least till next update) and therefore will suppress a number of sarcastic remarks. And I will accept this solution.

Kai-H 27,310 Reputation points Microsoft External Staff Moderator

2026-06-18T06:12:41.2366667+00:00

Glad to hear that the issue has been resolved.

Have a nice day!