Match, 218 match – Apple iWork '09 User Manual
Page 218
Related Topics
For related functions and additional information, see:
“Listing of Reference Functions” on page 206
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
MATCH
The MATCH function returns the position of a value within a range.
MATCH(search-for, search-where, matching-method)
Â
search-for: The value to find. search-for can contain any value type.
Â
search-where: The collection containing the values to be searched. search-where is
a collection containing any value type.
Â
matching-method: An optional value specifying how value matching is performed.
find largest value (1 or omitted): Find the cell with the largest value less than or
equal to search-for. Wildcards can’t be used in search-for.
find value (0): Find the first cell with a value that exactly matches search-for.
Wildcards can be used in search-for.
find smallest value (–1): Find the cell with the smallest value greater than or equal
to search-for. Wildcards can’t be used in search-for.
Usage Notes
MATCH works only on a range that is part of a single row or column; you can’t use it
Â
to search a two-dimensional collection.
Cell numbering starts with 1 at the top or left cell for vertical and horizontal ranges,
Â
respectively. Searches are performed top-to-bottom or left-to-right.
When searching for text, case is ignored.
Â
218
Chapter 9
Reference Functions