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.
Deze oefening maakt deel uit van de cursus
Data-analyse in Google Sheets
Oefeninstructies
- In
F3:F10, look up the grade for each GPA score.
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen