Check result from XLOOKUP if_missing parameter and XMATCH with #DIV/0!

Excel-DNA / XFunctions

XLOOKUP and XMATCH for all Excel versions

MIT License

40 stars 21 forks source link

Closed govert closed 4 years ago

govert commented 4 years ago

In v3.0 this function still returns #N/A:

=XLOOKUP.FROM.ADDIN("a", {"b","c"}, {1,2}, 0)

Also check #DIV/0 ordering for XMATCH with:

=1/0
1
 
=XMATCH(0, A1:A2,1)
=XMATCH.FROM.ADDIN(0, A1:A2,1)

govert commented 4 years ago

This should be fixed in v0.4-beta.