https://bugs.documentfoundation.org/show_bug.cgi?id=155843
Bug ID: 155843
Summary: LOOKUP function not working properly
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: liammcgillivra...@gmail.com
Created attachment 187918
--> https://bugs.documentfoundation.org/attachment.cgi?id=187918&action=edit
This bug is apparent on Row 2 of this spreadsheet.
The LOOKUP function is not doing what it's supposed to, despite being used
exactly as described in the Help section. The search vector & result vector are
both one column.
But I cannot figure out exactly how it determines the output. For the first
many columns of cells I use as the search criterion, the function outputs
"#N/A". I confirmed that the spellings do indeed match. But when I use a search
criterion value that matches the first cell in the search vector column, I get
the correct value. But then using any cells to the right of this one as input
gives me the same output; the value of the first cell in the result vector.
I don't know what it's doing, but it's not what it's supposed to do.
I included the file as an attachment. See cells on the second row where this
function is being used. It's supposed to return the 3-letter country code of
the cell above.
--
You are receiving this mail because:
You are the assignee for the bug.
