For convenience only,grade(G5:G9) andscore(F5:F9) arenamed ranges.
Instead, the table acts to group scores into buckets.
In this example, the formula uses MATCH to find the correct row for a given score.
In this case, the score is 79, so MATCH returns 3.
Now that we have the correct row number, we need to retrieve the grade in that row.
This is a job for the INDEX function.
The INDEX function
TheINDEX functionis designed to retrieve values at a known location.
In this example, the MATCH function returns a result of 3 directly to the INDEX function as therow_numargument.
For more information, see ourMATCH function page.
you’re free to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
