https://issues.apache.org/ooo/show_bug.cgi?id=123502
Bug ID: 123502
Issue Type: DEFECT
Summary: MATCH returns last position for empty value
Product: Calc
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
MATCH(<empty cell>;A1:A5) returns 5
It used to be #N/A as:
VLOOKUP(<empty cell>;A1:A5;1) returns #N/A
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
