https://bugs.documentfoundation.org/show_bug.cgi?id=164148
Bug ID: 164148
Summary: XLOOKUP gives #N/A instead of results with binary
search and exact match
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
XLOOKUP gives #N/A instead of results with binary search and exact match.
See attached file. Column B has XLOOKUP that does a binary search / exact match
in tab 'Kenteken'. Except for 1 result all results are #N/A.
The other columns show the correct results, based on the settings of XLOOKUP.
Also VLOOKUP and INDEX/MATCH give the expected results.
Steps to Reproduce:
See attached file.
Formula with #N/A results: =XLOOKUP(A2;$Kenteken.A:A;$Kenteken.A:A; ;0;2)
Actual Results:
XLOOKUP gives result #N/A
Expected Results:
XLOOKUP gives actual results, looked up and found in search matrix.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: kf6 (cairo+wayland)
24.8.3-1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
