=MATCH(3,A2:A5,1) : Match « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. Match
Input the formula: =MATCH(3,A2:A5,1). Press Enter to get the result.
Input the formula: =MATCH(3,A2:A5,1)
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)