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.
Deze oefening maakt deel uit van de cursus
Data Analysis in Google Sheets
Oefeninstructies
- 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.
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen