[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 14:16:10 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=141989
--- Comment #5 from Mike Kaganski <mikekaganski at hotmail.com> ---
> 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.
--
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/44936966/attachment.htm>
More information about the Libreoffice-bugs
mailing list