VLOOKUP function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to look up a value in the first column of a table and return the value from the second column.

Excel

=VLOOKUP(A2, B2:D10, [1], FALSE)

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

A2

B3

C1

D4

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 as the column index returns the lookup value itself.

Using a column index greater than the number of columns in the table causes an error.

The third argument in VLOOKUP is the column index number from which to return the value. Since we want the second column, we use 2.

2fill in blank

medium

Complete the formula to perform an exact match lookup for the value in cell A5.

Excel

=VLOOKUP(A5, A1:C20, 3, [1])

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

AFALSE

BTRUE

C0

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRUE instead of FALSE causes approximate matches.

Omitting the fourth argument defaults to TRUE, which may not be desired.

The fourth argument in VLOOKUP specifies whether to find an approximate match (TRUE) or exact match (FALSE). For exact match, use FALSE.

3fill in blank

hard

Fix the error in the formula to correctly look up the value in cell B3 and return the value from the fourth column.

Excel

=VLOOKUP([1], A1:D15, 4, FALSE)

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

AD3

BB3

CC3

DA3

Attempts:

3 left

💡 Hint

Common Mistakes

Using a cell reference outside the lookup value.

Using a column reference instead of a cell reference.

The lookup value should be the cell B3 as stated. Using B3 ensures the formula looks up the correct value.

4fill in blank

hard

Fill both blanks to create a VLOOKUP formula that looks up the value in cell C2, searches the range A2:E20, and returns the value from the fifth column with an exact match.

Excel

=VLOOKUP([1], [2], 5, FALSE)

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

AC2

BB2

CA2:E20

DA1:D20

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong cell for lookup value.

Using a range that does not include the lookup value column.

The lookup value is cell C2, and the table array is the range A2:E20. The formula returns the value from the fifth column with exact match.

5fill in blank

hard

Fill all three blanks to create a VLOOKUP formula that looks up the value in cell D4, searches the range B1:F30, and returns the value from the third column with an exact match.

Excel

=VLOOKUP([1], [2], [3], FALSE)

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

AD4

BB1:F30

C3

DE4

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong column index.

Using a lookup value outside the table array.

The lookup value is D4, the table array is B1:F30, and the column index is 3 to return the third column's value with exact match.