[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 #6 from Colin <that.man.colin at gmail.com> ---
(In reply to Mike Kaganski from comment #5)
> > Is there a reason why it works as expected for 10 of the twelve events?
> 
> By the way, it didn't. It showed February's result when you chose July;
> August's result for October and November; so it in fact failed 5 times out
> of 12. And the wrong results are actually even more dangerous if you use
> VLOOKUP incorrectly, since you may (and did!) overlook that.

Wow, thanks for your efforts, Mike.
It's been a good day for me - I learned two things.
Sorry I wasted your time

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