Microsoft® Excel® 2010 Formulas & Functions Inside Out

MATCH()

Syntax. MATCH(lookup_value,lookup_array,match_type)

Definition. This function searches for text, numbers, or logical values within a reference or an array and returns the position.

Arguments

• lookup_value (required). The number, a string, a logical value, or a reference to a cell containing a value.

• lookup_array (required). A contiguous range of cells consisting of one row or one column, or an array constant.

• match_type (optional). Must evaluate to a number (–1, 0, or 1). Determines how the lookup_value is matched in the search array. If this argument is omitted, Excel uses the value 1.

  The match_type argument is set as follows:

  • If match_type is –1, the MATCH() function returns the position of the smallest value greater than or equal to lookup_value ...