Microsoft KB Archive/59483

{| = MATCH Function Equivalent with Data in Ascending Order =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q59483 The information in this article applies to:
 * Microsoft Excel for Windows, versions 2.0, 2.1 and 3.0
 * Microsoft Excel for OS/2, versions 2.2 and 3.0

SUMMARY
The following article describes a technique to perform the equivalent of the MATCH function with type -1, but with the data in ascending order. This formula finds the smallest value that is greater than or equal to the lookup_value.

MORE INFORMATION
The following is an example using the formula:

A1: 4.3   B1:  1.1 A2:       B2:  2.2 A3:       B3:  3.3 A4:       B4:  4.4 A5:       B5:  5.5 Cells B1 through B5 have been defined as &quot;range1.&quot; The formula, which could be placed in cell A2, is as follows:

=IF(INDEX(range1,MATCH(A1,range1))=A1,MATCH(A1,range1),   MATCH(A1,range1)+1) In this example, this formula would return 4, the location of the value 4.4.
 * }