https://bugs.documentfoundation.org/show_bug.cgi?id=155548
Bug ID: 155548
Summary: VLOOKUP and MATCH - random results
Product: LibreOffice
Version: 7.4.6.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Under LibO 7.4.6 (problem not seen since 3.x, not tested above),
VLOOKUP(lookup value 1; table_array 1; MATCH(lookup_value 2; table_array
2;0);0) seems to work randomly.
Sometimes, it's OK and sometimes, though the solution exists, it returns
"#N/D".
Removing lines in table array can change the result.
Windows 10 pro (x64) / LibO 7.4.6.2 (x64)
Steps to Reproduce:
1.use VLOOKUP
2.use MATCH, as col_index_num in VLOOKUP
3.
Actual Results:
I don't really know
Expected Results:
Sometimes works, sometimes returns "#N/D"
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
A value from a sheet
--
You are receiving this mail because:
You are the assignee for the bug.
