Which returns “B”, the correct grade for a score of 88. Note that the last argument is 1 (equivalent to TRUE), which allows MATCH to perform an approximate match on values listed in ascending order. In this configuration, MATCH returns the position of the first value that is less than or equal to the lookup value. In this case, the score is 88, row 4 is returned. Once MATCH returns 4 we have: Which causes INDEX to retrieve the value at the 4th row of the range C5:C9, which is “B”. Note: values in column B must be sorted in ascending order in order for MATCH to return the correct position.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
