Match « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






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)