A more versatile alternative to VLOOKUP and HLOOKUP that can look in any direction and defaults to exact matches. XMATCH: A modern version of the MATCH function.
Once you have the .xll file, follow these steps to enable the functions in your spreadsheets:
XFunction 64: How to Download and Install XLOOKUP for Free If you are using an older version of Microsoft Excel, like Excel 2013, 2016, or 2019, you might have noticed that modern formulas like and XMATCH are missing. While these functions are built into Microsoft 365 and newer versions, they aren't natively available for legacy installations. xfunction 64 download free
The safest and most reliable place to download the add-in is from its official repository.
Tip: To check your version, open Excel and go to . It will specify if you are running 32-bit or 64-bit. Installation Guide A more versatile alternative to VLOOKUP and HLOOKUP
(specifically the file ExcelDna.XFunctions64.xll ) is a small add-in built using the Excel-DNA library . It serves as a compatible bridge, implementing XLOOKUP and XMATCH for Windows desktop versions of Excel that don't already have them.
Go to the official Excel-DNA XFunctions Releases on GitHub. While these functions are built into Microsoft 365
The "64" version is designed specifically for 64-bit Office installations, which are common on modern Windows machines. How to Download XFunction 64 for Free