https://bugs.documentfoundation.org/show_bug.cgi?id=167698
Bug ID: 167698
Summary: Calc vlookup function not showing #NA, returns last
result , [1] ⓘ
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
It seems I have discovered a bug with Calc, and vlookup function.
Steps to Reproduce:
1.two tables with name and data
2.create vlookup from one table to other
3.copy down vlookup function
Actual Results:
if look up does not find the criterion after the first row the result returned
is the previous line above result, not #NA
Expected Results:
If name not in lookup range result should be #NA
Reproducible: Always
User Profile Reset: No
Additional Info:
I found this while sorting two data sources and was using IFNA but result were
not as expected and I found the fault was with vlookup result.
I created a simple sheet and recreated the error.\
I did just update to i thought 25.8 as I want the unique function.
But info below dont reflex this.
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 20; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 4:25.2.5~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
