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.