HLOOKUP function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to look up the value in the first row and return the value from the second row.

Excel

=HLOOKUP(A1, B1:D2, [1], FALSE)

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

A3

B1

C0

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 as the row index returns the lookup value itself, not the result.

Using 0 or a number larger than the number of rows causes errors.

The HLOOKUP function looks for a value in the first row of a range and returns a value from the specified row number. Here, to get the value from the second row, use 2.

2fill in blank

medium

Complete the formula to perform a case-insensitive exact match lookup.

Excel

=HLOOKUP("Apple", A1:D2, 2, [1])

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

AFALSE

BTRUE

C0

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRUE causes approximate matches which may return wrong results.

Using 0 or 1 instead of TRUE or FALSE can cause confusion.

The last argument in HLOOKUP specifies if the match should be approximate (TRUE) or exact (FALSE). For exact match, use FALSE.

3fill in blank

hard

Fix the error in the formula to correctly return the value from the third row.

Excel

=HLOOKUP(B1, A1:D3, [1], FALSE)

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

A2

B3

C1

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 2 returns the second row, not the third.

Using 0 or 1 returns wrong or the lookup row.

The row index must be 3 to get the value from the third row in the range.

4fill in blank

hard

Fill both blanks to create a formula that looks up the value in cell C1, searches the range A1:E3, and returns the value from the second row with an exact match.

Excel

=HLOOKUP([1], [2], 2, FALSE)

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

AC1

BA1:E3

CB1:D2

DTRUE

Attempts:

3 left

💡 Hint

Common Mistakes

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

Using TRUE instead of FALSE for exact match.

The first blank is the lookup value cell C1. The second blank is the range A1:E3 where the lookup happens.

5fill in blank

hard

Fill all three blanks to create a formula that looks up the value in cell B2, searches the range A1:D4, and returns the value from the fourth row with an exact match.

Excel

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

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

AB2

BA1:D4

C4

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong row index like 3 instead of 4.

Using a range that does not include the fourth row.

The lookup value is cell B2, the range is A1:D4, and the row index is 4 to get the fourth row's value.