Excel-DNA XFunctions: XLOOKUP and XMATCH for all Excel versions

[Govert van Drimmelen]

I'm making a small add-in that defines XLOOKUP and XMATCH functions to match the recently announced built-in functions (https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376).

The add-in is called XFunctions and hosted here: https://github.com/Excel-DNA/XFunctions

So far I have only implemented the default 'exact first-item match' case (with and without wildcards), but for that case the two functions should work correctly, even returning a reference when the built-in XLOOKUP function would do so. For now I have not posted binaries to download quite yet.

I'm happy to accept any help or feedback - the code is a rough first pass but might be a nice little project to get involved in.

There are also some tricky decisions relating to backward and forward compatibility to make...

When we have a first release ready for testing I'll add to this discussion.

-Govert

[Govert van Drimmelen]

I have now made a first test release that should cover the announced functionality of XLOOKUP and XMATCH - see https://github.com/Excel-DNA/XFunctions/releases

The implementation should be 'complete' in that all the parameter options are covered.

But I do expect bugs in the advanced cases - I haven't done any testing yet....

Please have a look - any feedback welcome.

-Govert