Google Sheets Test Google Sheets Advanced Lookup Functions 4

Question 1

You need to look up a value and return the result from a column to the LEFT of it. Which approach works?

Accepted Answer

INDEX/MATCH or XLOOKUP

Answer

VLOOKUP cannot look left, but INDEX/MATCH and XLOOKUP can return values from any direction.

Question 2

What is the result of an XLOOKUP when the lookup value is missing and no if_not_found argument is given?

Accepted Answer

#N/A

Answer

Without an if_not_found value, XLOOKUP returns #N/A when no match exists.

Question 3

Why might a VLOOKUP return #N/A even though the value visibly appears in the table?

Accepted Answer

Hidden extra spaces or a number stored as text mismatch

Answer

Trailing spaces or type mismatches (text vs. number) cause exact matches to fail silently.

Question 4

Which function combination lets you look up a value based on two criteria at once?

Accepted Answer

INDEX with MATCH using concatenated keys

Answer

Concatenating criteria inside MATCH (or using multiplication in an array) enables multi-criteria lookups.

Question 5

In =INDEX(C2:C10, MATCH(E2, A2:A10, 0)), what does the 0 in MATCH mean?

Accepted Answer

Exact match

Answer

A match_type of 0 tells MATCH to find an exact match, the safest option for unsorted data.

Google Sheets Test Practice Test