Thanks Francis. I would have thought that Excel would have mentioned the
descending order a little more clearly. However, it does make sense. Thanks
again for you help.

DoubleZ

"francis" wrote:

using -1 requires that the lookup_array must be placed in descending order and
will finds the smallest value that is greater than or equal to lookup_value

if you want to return 6 for 5.7 as lookup value, try
=MATCH(MROUND(5.7,1),A1:A10,0)

Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"DoubleZ" wrote:

In Excel 2007 I am using the MATCH function and trying to return the next
greatest value. For some reason, entering -1 as the match type is returning
a #N/A error. I tried a very simple example and it is still returning the
same error. In cells A1:A10 I have the values 1 through 10 (in ascending
order). In cell B1 I have:
=MATCH(5.7,A1:A10,-1). I would think this should return 6 because it rounds
up to 6 which is in the sixth row of the array.

Please help.