Excel-DNA XFunctions v0.2-alpha

The Excel-DNA XFunctions add-in provides implementations of the XLOOKUP and XMATCH functions that are compatible with the built-in functions introduced in August 2019.

Version 0.2 of the add-in is an early test version that implements the two functions, and should run in any Windows desktop version of Excel.

To install just download the matching ExcelDna.XFunctions.xll or ExcelDna.XFunction64.xll binary for 32-bit or 64-bit Excel into any local directory, and the pick File -> Open to load, or press Alt+t,i to show the Add-ins dialog and install. Two test files that exercise the functions can also be found below.

WARNING! I have not tested this yet - expect fixes and changes.
Please have a look and post bug reports on GitHub or on the Excel-DNA discussion group.

-Govert

Changelog

v 0.2 - Fixes issue #1 where exact matches did not escape wildcards correctly