For convenience only, the range F5:G9 has beennamedkey.
VLOOKUP function
VLOOKUP is an Excel function to get data from a table organizedvertically.
With a score provided as a lookup value, VLOOKUP will scan the first column of the table.
If it finds an exact match, it will return the grade in that row.
Whenrange_lookupis omitted, it defaults to TRUE and VLOOKUP performs an approximate match.
Providing a value for range_lookup acts as a reminder to you and others of the intended behavior.
In the example shown, we use zero in cell F5 to double-check this does not occur.
(2) you could useINDEX and MATCH to solve this same problem.
