MATCH¶
Returns a relative position number of a matching cell inside a specified cell range.
Syntax
=MATCH(Value, SearchRange [, Type])
Arguments
Name 
Description 

value 
Value to search for. 
SearchRange 
A cell range to search in. 
Type 
Optional. Search type with the following options:
1: (Default) Find the largest value in cell range which is less than or equal to specified value. Table must be in ascending order.
0: Find the first value which match exactly specified value. Here the wildcards ? and * are supported.
1: Find the smallest value in cell range which is greater or equal to specified value. Table must be in descending order.

Return Value
Returns relative position of in cellrange for given value or #NA if no match is found.
Example
Function 
Result 
Comment 

1. –> 2
2. –> 1

The index of the cell with the searched value is returned. 