XLOOKUP and XMATCH functions support

[tonyqus]

Migrate functions from POI

[tonyqus]

XLookup
apache/poi#243
XMatch
apache/poi@c0681f0

[503049007-bh]

Thanks! This was roadblocker for using NPOI at one of companies as they have tons of those calls in their sheets.

[tonyqus]

I am almost there. But when I open the Excel file including XLookup function, I got #Name error in my Office 2016 (local installation). Is this a new function in Office 365 only?

Here is the file generated by NPOI. Can you show me if it works on your side?
xlook76803c35-1170-44d0-8490-1bdc4aa5c3c0.xlsx

[tonyqus]

#815

[503049007-bh]

No it doesn't work (checked your file in O365 and 2016) i can see #NAME error as well but SYNTAX is correct!
Without any change if I go to cell and press Ctrl + Shift + Enter starts working...
Did you try also non-matrix mode? So in your file put :

• in cell C2: =XLOOKUP(B2,B5:B14,C5:C14)
• in cell D2 =XLOOKUP(B2,B5:B14,D5:D14)