behaviour of Calc function MATCH

[Winfried Donkers]

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