https://bugs.documentfoundation.org/show_bug.cgi?id=141989
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #2 from Mike Kaganski <[email protected]> ---
Formula in B8 is
> =VLOOKUP(A4;Sales;B5)
which uses sorted range lookup [1]. It requires that the search column be
sorted ascending, which is obviously not the case. Your data is not sorted, and
thus you need 0 as the fourth argument.
This is not a bug.
[1]
https://help.libreoffice.org/latest/en-US/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
