★0 XP
Question 1 of 10
The MATCH function searches a range for a lookup value and returns its position in the range. Try typing =MATCH(15, A1:A6, 0) to return 5.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 22 | |||
| 2 | 13 | |||
| 3 | 9 | |||
| 4 | 18 | |||
| 5 | 15 | |||
| 6 | 14 |
B1fx
Question 1 of 10
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 22 | |||
| 2 | 13 | |||
| 3 | 9 | |||
| 4 | 18 | |||
| 5 | 15 | |||
| 6 | 14 |