https://bugs.documentfoundation.org/show_bug.cgi?id=146470
Bug ID: 146470
Summary: Search array has exact match - VLOOKUP - unsorted -
does not return a value
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 177188
--> https://bugs.documentfoundation.org/attachment.cgi?id=177188&action=edit
File to demonstrate the issue.
Using unsorted vlookup (ie. last parameter is FALSE()), VLOOKUP returns "#N/A"
even though the search array has exact match.
To make things more strange, (re)saving this file in .XLSX format and opening
it, the VLOOKUP functions properly.
Items on the file:
B6:C12 - Array with values
B3 - Exact value from B9
C4 - Formula: VLOOKUP(B3;B6:C12;2;false())
The value shown on C4 is #N/A
Version: 7.2.4.1
Build ID: 20(Build:1)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: fi-FI (en_IE.utf8); UI: en-US
Calc: threaded
Steps to produce:
Open the attached file
Copy (ctrl-c) any of the values in B6:B12 and paste (ctrl-v) it to B3
See value on C4. If "#N/A" - it's error
Save as... .XLSX
Close file
Open the .XLSX file
See value on C4 - Now contains proper value.
--
You are receiving this mail because:
You are the assignee for the bug.
