Two-Way Lookups: INDEX/MATCH/MATCH and Nested XLOOKUP
This lesson is part of the course
In this lesson
You pull one number from Ridgecrest's region × month sales matrix in two ways, build a row that follows the selected region and chart it.
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
- VLOOKUP Exact Match and Its Pitfalls Locked
- Approximate Match: Discount Tiers and Shipping Bands Locked
- XLOOKUP: If Not Found, Match Modes and Last-to-First Search Locked
- INDEX/MATCH and Left Lookups Locked
- Two-Way Lookups: INDEX/MATCH/MATCH and Nested XLOOKUP Locked
- Multiple-Criteria Lookups: Helper Keys vs MATCH(1,(…)*(…),0) Locked
- Wildcards & Partial Matches: *, ? and ~ Locked
- Capstone: A Lookup-Driven Sales Report with Error Handling Locked