Hi Eike,
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 containin
Hi Winfried,
On Friday, 2022-12-16 16:05:19 +0100, Winfried Donkers wrote:
> 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#__Ref
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
htt
