开始使用免费开始使用

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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习