Unsorted lookups
It's good data practice to keep information relating to different entities in separate tables, but there are many use cases for combining this information to draw insights from data. Lookups allow you to find and return information in another table based upon a key, or common value, present in both tables.
In this exercise, you'll utilize lookups to find course titles and the number of credits awarded from course codes.
本练习是课程的一部分
Google Sheets 数据分析
练习说明
- In
B3:B10, look up the class name for each course code inC3:C10. - In
D3:D10, look up the number of credits associated with each course.
