We continuously improve the add-in and implement even more custom functions. The add-in contains useful functions for various purposes. Take a look at how the built-in tooltips work: What is DataFXĭataFX is a user-defined function library for Microsoft Excel. It is equal to the Microsoft 365 version. Once the add-in is installed, you can use the DXLOOKUP function. This add-in works in: Excel 2013 or later on Windows, Excel on the web, Excel 2016 or later on Mac, PowerPoint 2013 or later on Windows, PowerPoint on iPad. NET Intellisense integration, the add-in provides native Excel tooltips. If you are unfamiliar with Excel add-ins, take a closer look at how to install an Excel add-in.

On the Developer Tab, click Excel Add-ins.

Steps to add XLOOKUP function for Excel 2013, 20 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. The XLOOKUP add-in enables you to use the only Microsoft 365 compatible function under Excel 2010, Excel 2013, Excel 2016, and Excel 2019.Įveryone wants to use XLOOKUP.

Microsoft excel free download 2013