I have the months of the year, in reverse alphabetical order, in the range
I1:I12 (i.e., September is in I1 and April is in I12, with the rest of the
months appearing within that range.

When I enter the formula =MATCH("October",I1:I12) the value 12 is returned.
Now, if I change the formula to =MATCH("October",I1:I12,0) then 2 is
returned, which is correct since "October" is the second value in the range,
going from top to bottom.

The question I have is that the discussion of the MATCH function that is
here, http://www.techonthenet.com/excel/formulas/match.php , indicates that
the default argument for the MATCH function, 1, searches for a value equal to
the one given in the formula.

So what am I missing here? Why is 0 required for me to get the correct
result?

Dave
--
Brevity is the soul of wit.