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.


  • 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 ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.