With a score provided as a lookup value, VLOOKUP will scan the first column of the table. In approximate match mode VLOOKUP assumes the table is sorted by the first column. Finally, the last argument for VLOOKUP, the confusingly named 'range lookup' is set to TRUE, to tell VLOOKUP to perform an 'approximate match'. The column index is provided as 2, since we want VLOOKUP to return a grade from the second column. The lookup table is the named range 'key' (B5:C9). In this example, the scores in column F are lookup values for the VLOOKUP function.
