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.
