[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]

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

--- Comment #3 from Colin <that.man.colin at gmail.com> ---
(In reply to Mike Kaganski from comment #2)
> 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

Thanks for clarifying.
Is there a reason why it works as expected for 10 of the twelve events?
Shouldn't it just fail miserably and everything return N/A?

-- 
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/4d070455/attachment.htm>