XLOOKUP Add-in for Excel 2013, 2016 and 2019

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

  1. Open Excel
  2. On the Developer Tab, click Excel Add-ins
  3. Click Browse and select the add-in
  4. Click OK
  5. XLOOKUP add-in is installed

Download the 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:

XLOOKUP add-in 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.

Istvan Vozar

Istvan is the co-founder of Visual Analytics. He helps people reach the top in Excel.