MATCH function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to find the position of the value 50 in the range A1:A10.

Excel

=MATCH(50, A1:A10, [1])

Drag options to blanks, or click blank then click option'

A0

B1

C-1

DTRUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 or -1 instead of 0 causes approximate matches.

Leaving the third argument blank defaults to 1, which requires sorted data.

The third argument in MATCH specifies the match type. Use 0 for an exact match.

2fill in blank

medium

Complete the formula to find the position of "Apple" in the range B2:B20 with an exact match.

Excel

=MATCH("Apple", B2:B20, [1])

Drag options to blanks, or click blank then click option'

A0

B1

C-1

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRUE or 1 when data is not sorted.

Using FALSE instead of 0.

Use 0 for exact match. Although FALSE coerces to 0, MATCH expects numeric -1, 0, or 1 for match_type.

3fill in blank

hard

Fix the error in the formula to find the position of 100 in C1:C15 with exact match.

Excel

=MATCH(100, C1:C15, [1])

Drag options to blanks, or click blank then click option'

ATRUE

BFALSE

C1

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using FALSE instead of 0; prefer numeric values.

Using TRUE or 1 without sorted data causes wrong results.

The third argument must be 0 for exact match. Although FALSE coerces to 0, use the numeric value.

4fill in blank

hard

Fill both blanks to find the position of the value in cell D5 within range E1:E20 with exact match.

Excel

=MATCH([1], [2], 0)

Drag options to blanks, or click blank then click option'

AD5

BE1:E20

CD6

DA1:A10

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the lookup value and range.

Using a wrong cell or range reference.

The first argument is the lookup value (D5). The second is the lookup range (E1:E20).

5fill in blank

hard

Fill all three blanks to find the position of the text in cell F3 within range G1:G30 with approximate match.

Excel

=MATCH([1], [2], [3])

Drag options to blanks, or click blank then click option'

AF3

BG1:G30

C1

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 instead of 1 for approximate match.

Using wrong cell or range references.

Use F3 as lookup value, G1:G30 as range, and 1 for approximate match.