https://bugs.documentfoundation.org/show_bug.cgi?id=132131
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #36 from Eike Rathke <[email protected]> ---
Nothing to fix or implement here. If you tell VLOOKUP() to do a range lookup by
not giving the 4th parameter at all then the lookup range MUST be sorted,
otherwise the result will be *arbitrary*. This is the same in Calc and Excel
though the result may be different arbitrary due to different search algorithms
and *by accident* may be what is expected in one or the other. See also
https://help.libreoffice.org/6.4/en-GB/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
