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 have not a Microsoft 365 subscriber, we have a piece of good news for you: Our add-in uses user-defined functions 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 on the ribbon
What is DataFX
DataFX is a custom function library for Microsoft Excel. The add-in contains useful user-defined functions for various purposes. We continuously improve the add-in and implement even more custom functions.
After the installation, the DataFX tab appears:
Once the add-in is installed, you can use the DXLOOKUP function. It is equal to the Microsoft365 version.
Here is a left lookup example: