MATCH(lookup_value,lookup_array,match_type) returns the relative position of an item in an array : Match « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






If match_type is 1, MATCH finds the largest value that is less than or equal to lookup_value. Lookup_array must be ascending.
If match_type is 0, MATCH finds the first value that is exactly equal to lookup_value. Lookup_array can be in any order.
If match_type is -1, MATCH finds the smallest value that is greater than or equal to lookup_value. Lookup_array must be descending.
If match_type is omitted, it is assumed to be 1.

Referenced from Excel Help









19.11.Match
19.11.1.MATCH(lookup_value,lookup_array,match_type) returns the relative position of an item in an array
19.11.2.=MATCH(3,A2:A5,1)=MATCH(3,A2:A5,1)
19.11.3.=MATCH(8,A2:A5,0)=MATCH(8,A2:A5,0)
19.11.4.=MATCH(0,A2:A5,-1)=MATCH(0,A2:A5,-1)