Excel Lookup Masterclass: XLOOKUP, INDEX/MATCH, VLOOKUP & Two-Way Lookups
Exact and approximate VLOOKUP, XLOOKUP match and search modes, INDEX/MATCH left lookups, two-way and multiple-criteria lookups, wildcards and an error-proof report in 8 hands-on labs at one company, every cell checked instantly.
The first 2 lessons are free — no account needed.
About this course
An Excel lookup functions course built on one fictional distributor of tools and safety gear, for analysts, office staff and anyone who has fought a #N/A error. You fill order lines with VLOOKUP exact match and make it survive inserted columns, give every order its discount tier and shipping band with an approximate match on sorted threshold tables, read a price-change log with XLOOKUP's if-not-found, match modes and last-to-first search, return a supplier name to the left of the ID with INDEX and MATCH, pull one number from a region by month matrix with INDEX/MATCH/MATCH and nested XLOOKUP, look up contract prices where only customer plus product is unique with a helper key and a Boolean MATCH, search the catalogue with wildcards and finish with an error-proof sales report. The first two labs are free.
Lessons
- 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