始める無料で始める

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.

この演習はコースの一部です

Google Sheetsで学ぶデータ分析

コースを見る

演習の手順

  • In F3:F10, look up the grade for each GPA score.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する