https://bugs.documentfoundation.org/show_bug.cgi?id=101988
Bug ID: 101988
Summary: LOOKUP of null value returns #NA
Product: LibreOffice
Version: 5.2.0.4 release
Hardware: All
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 127213
--> https://bugs.documentfoundation.org/attachment.cgi?id=127213&action=edit
Spreadsheet showing bug
If you construct a LOOKUP function to search for a null value, such as:
=LOOKUP("",Range_B,Range_A)
in LibreOffice, it returns a value of: #N/A
The function works as expected in Excel and OpenOffice, returning the last
value in Range_A for which there is not a null value in Range_B.
Please see attached spreadsheet for a simple example of the bug.
I will update bug report with PDFs showing the difference between OpenOffice
and LibreOffice results. (Since you apparently can't attach multiple files!)
THANKS!
JK
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
