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.
