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 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

  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 on the ribbon

Download the zip file from here. If you are unfamiliar with Excel add-ins, take a closer look at how to install an Excel add-in.

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:

add-in ribbon tab

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:

xlookup compatibility usage excel 2010 2013 2016 2018

Stay tuned.

Istvan Vozar

Istvan is the co-founder of Visual Analytics Ltd. He writes blog posts and helps people to reach the top in Excel.