Task 1 of 5
In D10:D13, look up the course name by code (exact-match VLOOKUP).
Lesson theory
A language school is enrolling students. Let's practice VLOOKUP (exact and approximate match), INDEX+MATCH and XLOOKUP.
Tip: always lock the reference table with $, otherwise it "slides" down when you fill the formula.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page