INDEX-MATCH combination in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to find the value in column B that matches the lookup value in cell E2 using MATCH.

Excel

=INDEX(B2:B10, [1](E2, A2:A10, 0))

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

ALOOKUP

BVLOOKUP

CHLOOKUP

DMATCH

Attempts:

3 left

💡 Hint

Common Mistakes

Using VLOOKUP instead of MATCH inside INDEX.

Forgetting the match_type argument in MATCH.

The MATCH function finds the position of the lookup value in the range A2:A10, which INDEX then uses to return the corresponding value from B2:B10.

2fill in blank

medium

Complete the formula to find the row number of the lookup value in A2:A20 using MATCH with exact match.

Excel

=MATCH([1], A2:A20, 0)

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

AC2

BB2

CA2

DD2

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong cell reference for the lookup value.

Omitting the match_type argument.

The lookup value is in cell B2, so MATCH uses B2 to find its position in A2:A20.

3fill in blank

hard

Fix the error in the formula to correctly return the value from column C matching the lookup value in E3.

Excel

=INDEX(C2:C15, MATCH(E3, [1], 0))

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

AB2:B15

BD2:D15

CA2:A15

DC2:C15

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong column range in MATCH.

Mixing up the lookup and return columns.

The MATCH function should search the lookup value E3 in the key column A2:A15, not in column C.

4fill in blank

hard

Fill both blanks to create a formula that returns the value from column D where the lookup value in F2 matches column A.

Excel

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

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

AD2:D20

BA2:A20

CB2:B20

DC2:C20

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the ranges for INDEX and MATCH.

Using the wrong columns for lookup or return.

INDEX returns a value from D2:D20, and MATCH finds the position of F2 in A2:A20.

5fill in blank

hard

Fill all three blanks to create a formula that returns the value from column C where the lookup value in G3 matches column B, using exact match.

Excel

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

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

AC2:C25

BG3

CB2:B25

DA2:A25

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong ranges for INDEX or MATCH.

Forgetting the exact match argument in MATCH.

INDEX returns from C2:C25, MATCH looks for G3 in B2:B25 with exact match (0).