Excel-DNA XFunctions v0.3-beta
Pre-releaseThe 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.3 of the add-in is a test version that implements the two functions, and should run in any Windows desktop version of Excel.
If the add-in is loaded into a version of Excel that already supports the XLOOKUP and XMATCH functions, the add-in will register the add-in functions under the names XLOOKUP.FROM.ADDIN and XMATCH.FROM.ADDIN respectively.
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.
Please have a look and post bug reports on GitHub or on the Excel-DNA discussion group.
-Govert