The XLOOKUP add-in enables you to use the only Microsoft 365 compatible function under Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
Everyone wants to use XLOOKUP. However, if you are not a Microsoft 365 subscriber, we have some good news: Our add-in uses a user-defined function to keep your Excel up to date.
Steps to add XLOOKUP function for Excel 2013, 2016 and 2019
- Open Excel
- On the Developer Tab, click Excel Add-ins
- Click Browse and select the add-in
- Click OK
- XLOOKUP add-in is installed
Download the DataFX add-in file from here.
If you are unfamiliar with Excel add-ins, take a closer look at how to install an Excel add-in.
Using the .NET Intellisense integration, the add-in provides native Excel tooltips. Once the add-in is installed, you can use the DXLOOKUP function. It is equal to the Microsoft 365 version.
Here is a simple left-lookup example:
Take a look at how the built-in tooltips work:
What is DataFX
DataFX is a user-defined function library for Microsoft Excel. The add-in contains useful functions for various purposes. We continuously improve the add-in and implement even more custom functions.
Stay tuned.
Related Formulas and Resources:
- XLOOKUP with Boolean OR logic
- How to fix the XLFN prefix in Excel Formulas