Google Sheets Test Google Sheets Advanced Lookup Functions 2

Question 1

In the formula =VLOOKUP(A2, D2:F10, 3, FALSE), what does the FALSE argument specify?

Accepted Answer

An exact match is required

Answer

FALSE (or 0) tells VLOOKUP to find an exact match rather than the nearest smaller value.

Question 2

Which function is generally preferred over VLOOKUP because it can look both left and right of the search column?

Accepted Answer

INDEX/MATCH

Answer

INDEX/MATCH can return values from any column, including those to the left of the lookup column.

Question 3

What will VLOOKUP return if the lookup value is not found and range_lookup is FALSE?

Accepted Answer

#N/A

Answer

An exact-match VLOOKUP returns #N/A when no matching value exists.

Question 4

In XLOOKUP, what is the purpose of the fourth (optional) argument?

Accepted Answer

The value to return if no match is found

Answer

XLOOKUP's fourth argument sets a default return value when the lookup fails, replacing IFERROR wrapping.

Question 5

Why does VLOOKUP break when a new column is inserted inside the table range?

Accepted Answer

The column index number no longer points to the intended column

Answer

VLOOKUP uses a fixed numeric column index, so inserting a column shifts the target and returns wrong data.

Google Sheets Test Practice Test