MATCH(V, R [, T])

 

Description

This function returns the relative position of the value V in the range R, according to the rule specified by T:

 

 

 

V can be a string or a numeric value.  If V is a string, T must be 0 or omitted.  If V is a string, it may contain the wildcard characters, asterisk (*) and question mark (?), to represent any sequence of characters and any single character, respectively.

 

Parameters

 

V

Value to be matched.

 

R

Range in which to match V.

 

T

Type of match.

 

Examples

 

Given:

 

 

MATCH(15, B1:B7) = 3

 

MATCH(30, B1:B7, 1) = 6

 

MATCH(30, B1:B7, -1) = 1

 

MATCH("Orange", A1:A7) = 2

 

MATCH("Can", A1:A7) = 5