I am working on implementing XLOOKUP in Calc.
Therefore I need to change some existing code (to avoid lots of nearly
identical code) and I came across a behaviour that I don't understand
with the functions MATCH and VLOOKUP.
=MATCH("b";{1,2,"d","e"};1) returns 2, which is in accordance with
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1018430_715980110
But =MATCH("b",B1:B4;1) with B1:B4 containing the values 1,2,"d","e"
returns #N/A, which IMHO is not in accordance with the ODF standard.
I know that Excel returns #N/A in both occasions.
Why does Calc's MATCH conform partly with Excel behaviour and partly
with the ODF standard? Is this intended behaviour?
So far, it proves difficult for me to implement XLOOKUP because of un
expected behaviour in use cases.
Winfried
