Wildcards & Partial Matches: *, ? and ~
This lesson is part of the course
In this lesson
You build a small search box for Ridgecrest's catalogue: the first SKU whose name contains a word, how many products match, their stock, and a pattern count with ?.
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