Two-Way Lookups: INDEX/MATCH/MATCH and Nested XLOOKUP
This lesson is part of the subscription
The first 2 lessons of this course are free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- VLOOKUP Exact Match and Its PitfallsFree
- Approximate Match: Discount Tiers and Shipping BandsFree
- XLOOKUP: If Not Found, Match Modes and Last-to-First Search Pro
- INDEX/MATCH and Left Lookups Pro
- Two-Way Lookups: INDEX/MATCH/MATCH and Nested XLOOKUP Pro
- Multiple-Criteria Lookups: Helper Keys vs MATCH(1,(…)*(…),0) Pro
- Wildcards & Partial Matches: *, ? and ~ Pro
- Capstone: A Lookup-Driven Sales Report with Error Handling Pro