Issue 117463 - Enable backward search in functions (MATCH, LOOKUP, VLOOKUP ...)
Summary: Enable backward search in functions (MATCH, LOOKUP, VLOOKUP ...)
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.0-dev
Hardware: PC Linux, all
: P2 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-03-18 21:46 UTC by wallace.maxted
Modified: 2013-11-18 20:00 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description wallace.maxted 2011-03-18 21:46:36 UTC
I want to find the last occurrence of a string in a sheet, but it seems there is no way to do this?

 =MATCH(".*TEXT.*", RANGE, 0) finds the first occurrence

 =MATCH(".*TEXT.*", RANGE, 0, -1) could find the last occurrence and perhaps

 =MATCH(".*TEXT.*", RANGE, 0, n) could find the nth occurrence
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:32:23 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 2 Edwin Sharp 2013-11-18 20:00:29 UTC
According help:
"If a higher value is found during the search in the column, the number of the previous row is returned."

In reality MATCH returns row number of last occurrence.

The enhancement given in description is useful.