[Libreoffice-bugs] [Bug 141989] Calc VLOOKUP from DATA VALIDATION cell returns N/A for two of the validated values

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Apr 30 11:16:32 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=141989

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210430/bd08a828/attachment.htm>


More information about the Libreoffice-bugs mailing list