Lookups: VLOOKUP, XLOOKUP and INDEX/MATCH (plus IMPORTRANGE)
This lesson is part of the course
In this lesson
You complete an order sheet by looking up product names, prices and customer discounts from two reference tables, and you handle an unknown SKU.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Sharing-Ready Tables: Tidy Data, Totals and Checks Locked
- SUMIFS and COUNTIFS Reports (and QUERY in Sheets) Locked
- Lookups: VLOOKUP, XLOOKUP and INDEX/MATCH (plus IMPORTRANGE) Locked
- Text and Dates: Clean Names, Build IDs and Due Dates Locked
- Data Validation Logic: Checking Form Responses with Formulas Locked
- Conditional Formatting for a Shared Inventory Sheet Locked
- A One-Page KPI Dashboard with a Chart Locked
- Team Task Tracker: Status Counts and Overdue Items Locked