Look up a price by an exact ID
Your goal: Enter a product ID, return its price, and handle missing or repeated IDs without hiding the rule.
Full task requirements
Fill G2:G4 with the price for each ID in F2:F4. Use an exact match, return the first match, and show Not found when no ID matches.
Find catalogue pricesFind the record for F2
- Find ID
- P-103 (F2)
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 |
Step 1 of 3
Find the record for F2
How the Excel rule works
Choose the first exact matching source record. A stored zero is a found value. If the ID is absent, explicitly choose No matching records.
Inspect selected records
No records selected yet.
First selected value