INDEX/MATCH and Left Lookups
This lesson is part of the course
In this lesson
You find a supplier's position with MATCH, return it with INDEX, then fill Ridgecrest's purchase orders with the supplier name to the LEFT of the ID and an expected delivery date.
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