MATCH

This function looks for a value a table or array and returns the offset value for the first instance.  The search-range is checked row by row from left to right, until the value is found.  If the search criteria is not met, the error #N/A! is returned.

Syntax

MATCH(lookup-expression,search-range,{method})

Arguments

lookup-expression	The value you are looking for.  This can be a number, text string, or reference.
search-range	The range or ranges to search.
method	The method of searching for the value.  The default is 1. If method < 0 Assumes decreasing values. Returns the smallest value that is greater than or equal to lookup-expression value. If method is 0 Returns first exact match. If method > 0 Assumes increasing values. Returns the largest value equal to lookup-expression value.

Example

MATCH(500,A2..F5,0)

This function searches cells A2 through F5 for the value 500.  It would return 3 if 500 was in cell A4.