https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #12 from Eike Rathke <[email protected]> --- MATCH and [HVX]LOOKUP never consider cell format and should not. What happens however is that if the search criterion can be interpreted as a number (which a date string is also) a numeric lookup is performed. IIRC that was implemented because Excel did it that way. That seems to have changed? Or Excel first tries to find the string match and only if there is none it retries with a conversion to number if possible? Anyhow, our XLOOKUP implementation is at least wrong for any case returning "no invoice" in attachment 193924, i.e. C8 and C10. Note that you may have to Ctrl+F9 hard recalculate to get the current implementation's results. -- You are receiving this mail because: You are the assignee for the bug.
