TEAMS:

Use VLOOKUP to search for exact matches or for the nearest value that is less than or equal to the search value, such as assigning a B grade for an 87% class average. The VLOOKUP function has the following three required arguments and one optional argument: (1) lookup_value, (2) table_array, (3) col_index_number, and (4) range_lookup. ................
................