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.
This exercise is part of the course
Data Analysis in Google Sheets
Exercise instructions
- 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.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise