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.
Diese Übung ist Teil des Kurses
<Kurs>Datenanalyse in Google Sheets</Kurs>Übungsanweisungen
- In
F3:F10, look up the grade for each GPA score.
Interaktive praktische Übung
Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis
Übung starten