https://bugs.documentfoundation.org/show_bug.cgi?id=154868
Bug ID: 154868
Summary: Incorrect LOOKUP result when Search contains '-'
Product: LibreOffice
Version: 7.4.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The main table contains a list of Lookups to determine a value for a particular
part.
All Cell formats have been set to TEXT
In this example, Cell B264 Contains 'TSSOP-48'
Cell C264 contains =LOOKUP(B264, Packages.$A$2:$B$208)
The Packages Table contains
Cell Ref A, B below
'TSSOP-16', 1
'TSSOP14', 17
'TSSOP20', 17
'TSSOP-48', 17
The Lookup function should return '17' but returns '1' suggesting that it's not
searching for an exact text match.
--
You are receiving this mail because:
You are the assignee for the bug.
