Find a value at a row and column intersection
Your goal: Use two labels to retrieve net units from a small matrix, even after rows and month columns move.
Full task requirements
In G5, retrieve net units for the product in G2 and month in G3. Match text without regard to case, use the first occurrence of a repeated label, and return Not found if either label is absent. Preserve zero and negative results.
Monthly net unitsLocate the first product label
Product · G2: "Aster"Month · G3: "Feb"
| # | |
|---|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 |
Step 1 of 3
Locate the first product label
Rules for this step
Match the complete product label without letter case. Select its first physical occurrence. Its position inside the lookup array differs from its worksheet row.
- Product · G2
- "Aster"
- Month · G3
- "Feb"
Your selected source cells will appear here.
- Position inside the lookup array
- —