Find a position with MATCH
Step 1 of 3
MATCH tells you where a value sits in a list: =MATCH(what, list, 0) returns its position, 1 for the first item, 2 for the second and so on.
Click Continue when you're ready.
Already know it? Type the formula straight into E2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Product | Price | Product | Position | ||
| 2 | Apples | 22 | Dates | |||
| 3 | Bananas | 18 | ||||
| 4 | Cherries | 45 | ||||
| 5 | Dates | 38 | ||||
| 6 | Figs | 6 | ||||
| 7 | Grapes | 30 | ||||
| 8 |
Need help?
Why this works
MATCH returns where a value sits in a list, not the value itself: Dates is the 4th item of A2:A7. The 0 asks for an exact match. On its own this is handy; next to INDEX it becomes a lookup.
Common mistake: Leaving out the 0. MATCH then assumes a sorted list and can return the wrong position.
The answer
- E2
=MATCH(1D2,2A2:A7,30)
In plain words: Find the position of 1the product in D2 in 2the list in A2:A7, 3only on an exact match.
+15 points