Sorted lookups
Lookups can not only be used to match on specific keys, but for a sorted lookup table, can be used to look up information based on where a key falls within a range of values.
In this exercise, you'll use vertical lookups to find the grade associated with each GPA score in the main table. A GPA score, or grade point average, is used to assess success over the entirety of an educational program.
Cet exercice fait partie du cours
<cours>Data Analysis in Google Sheets</cours>Instructions de l’exercice
- In
F3:F10, look up the grade for each GPA score.
Exercice interactif pratique
Transformez la théorie en action avec l’un de nos exercices interactifs
Commencer l’exercice