How to Fix the _xlfn. Prefix Before XMATCH in Excel
Question details
The user needs to remove the _xlfn. prefix that appears before the XMATCH function in their Excel workbook so the formula can calculate properly.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening or editing an existing spreadsheet that contains the XMATCH function.
- Observed behavior
- The XMATCH function is prefixed with _xlfn., which indicates that the current Excel environment does not recognize the function due to version limitations or compatibility mode.
Check your current Microsoft Excel version, as the XMATCH function is natively supported only in Microsoft 365, Excel 2021, and newer versions.
Update Excel and Disable Compatibility Mode
Use this solution to ensure your Excel environment is fully up-to-date and not restricting modern functions through legacy compatibility modes.
The _xlfn. prefix is Excel's way of indicating that a function exists in the workbook's code but is not supported by the version currently rendering it. Updating your software and checking the file format will usually resolve this.
Open Excel, navigate to 'File' > 'Account' (or 'Office Account'), click on 'Update Options', and select 'Update Now' to install the latest Office updates.
Go to 'File' > 'Info'. If you see 'Compatibility Mode' next to the document name, click the 'Convert' button to upgrade the workbook to the current .xlsx format.
After updating and converting, click into the cell containing the _xlfn.XMATCH formula, remove the _xlfn. prefix manually if it remains, and press Enter to recalculate.
Restart Excel and Your Computer
Perform a system restart to clear temporary software glitches that might cause Excel to temporarily fail at recognizing built-in functions.
Replace XMATCH with Standard MATCH
Use this workaround if you are permanently using an older version of Excel (like Excel 2016 or 2019) that will never support the XMATCH function.
Switch to WPS Office to Handle Modern Spreadsheets
If your current version of Microsoft Office does not support newer functions like XMATCH and you want to avoid expensive subscription upgrades, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for modern spreadsheet tasks.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software suite on your computer.
- 2. Open WPS Spreadsheets: Launch the WPS Spreadsheets application from your desktop or start menu.
- 3. Load Your Workbook: Open your existing .xlsx file directly in WPS Office to view, edit, and calculate your data without formatting issues.

Frequently Asked Questions
What exactly does the _xlfn. prefix mean in Excel?
The _xlfn. prefix stands for 'Excel Function'. It is a marker automatically added by Excel when a workbook contains a function that is not natively supported by the specific version of Excel you are currently using.
Can I simply delete the _xlfn. prefix to make XMATCH work?
No. If you manually delete the _xlfn. prefix without updating Excel or replacing the function, Excel will still not recognize the formula and will instead return a #NAME? error.
Which versions of Microsoft Excel support the XMATCH function?
The XMATCH function is natively supported in Microsoft 365, Excel 2021, and Excel for the Web. It is not available in standalone older versions like Excel 2019, 2016, or 2013.
Why am I seeing this error if I have Microsoft 365?
If you have Microsoft 365 but still see this error, you might have opened an older .xls file in Compatibility Mode, or your Office installation may be experiencing a temporary background glitch that requires a quick restart or software update.




