The XLOOKUP add-in enables you to use only Microsoft 365-compatible functions in 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.
The add-in provides native Excel tooltips using the .NET Intellisense integration. Once the add-in is installed, you can use the DXLOOKUP function, which 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: