Lookup Functions
Advanced
Lookup with Wildcards
Use wildcard characters in lookup functions for partial matching.
Task:
You need to find product information based on partial names. Find products containing specific text using wildcards to locate the product name and price in columns B and C.
Learning Objectives:
- Learn wildcard usage in lookups
- Understand partial matching
- Practice flexible search techniques
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Product | Category | Price |
| 2 | Gaming Laptop | Electronics | 1299 |
| 3 | Office Chair | Furniture | 199 |
| 4 | Gaming Mouse | Electronics | 79 |
| 5 | Standing Desk | Furniture | 399 |
| 6 | |||
| 7 | Search Term | Found Product | Price |
| 8 | *Gaming* | ||
| 9 | *Chair* |
What this exercise teaches (contains the answer)
Wildcards allow for flexible pattern matching in lookup functions. The asterisk (*) matches any sequence of characters, while the question mark (?) matches exactly one character.