Issue 117463

Summary:	Enable backward search in functions (MATCH, LOOKUP, VLOOKUP ...)
Product:	Calc	Reporter:	wallace.maxted
Component:	programming	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P2	CC:	elish, issues
Version:	4.1.0-dev
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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.