[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 #9 from Colin <that.man.colin at gmail.com> ---
(In reply to Mike Kaganski from comment #8)
> (In reply to Colin from comment #7)
> > How could it "find" and return the "wrong" location? It couldn't have
> > matched the string at that location so I would have expected more N/As
> 
> Please read the description of the mode:
> if it didn't find
> perfect match, then the earliest value of the two last checks is the one it
> was looking for (it consider it "smaller"). Hence the wrong, but still
> found, results.

That's much clearer. Interestingly, I have used the "gap" between two dates in
precisely the manner you demonstrated but as the array was always intended to
return the next lower date I hadn't appreciated the implication when I wasn't
looking for the "gap". I must be getting old and forgetful.
Thanks again for your patience.

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