Formulas and Functions

Related Topics
For related functions and additional information, see:
“HLOOKUP” on page 211
“MATCH” on page 218
“VLOOKUP” on page 223
“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 nd. 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.
nd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.
ndvalue(0):Find the rst cell with a value that exactly matches search-for.
Wildcards can be used in search-for.
nd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