Look up a rate with multiple criteria
Your goal: Match three fields on the same row, return the first rate, and count complete matches before treating the key as unique.
Full task requirements
Return in G6 the numeric rate from the first source row whose Product, Region and Tier all match G2:G4, after lowercasing each text key. Keep spaces and punctuation exactly as stored. Return Not found if no complete row matches. In G7, count all complete matches, including a first rate of zero or a refund.
Three fields select one rateMatch the product
- Product
- "Aster" (G2)
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Step 1 of 3
Match the product
How the Excel rule works
Keep every record that meets the conditions shown so far. After Product, Region and Tier all match on the same row, return the first source rate. Spaces and punctuation stay meaningful.
Inspect selected records
No records selected yet.
First selected value