Google Sheets Advanced Lookup Functions Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Advanced Lookup Functions flashcards as text
In the formula =VLOOKUP(A2, D2:F10, 3, FALSE), what does the FALSE argument specify?
Answer: An exact match is required
FALSE (or 0) tells VLOOKUP to find an exact match rather than the nearest smaller value.
Which function is generally preferred over VLOOKUP because it can look both left and right of the search column?
Answer: INDEX/MATCH
INDEX/MATCH can return values from any column, including those to the left of the lookup column.
What will VLOOKUP return if the lookup value is not found and range_lookup is FALSE?
Answer: #N/A
An exact-match VLOOKUP returns #N/A when no matching value exists.
In XLOOKUP, what is the purpose of the fourth (optional) argument?
Answer: The value to return if no match is found
XLOOKUP's fourth argument sets a default return value when the lookup fails, replacing IFERROR wrapping.
Why does VLOOKUP break when a new column is inserted inside the table range?
Answer: The column index number no longer points to the intended column
VLOOKUP uses a fixed numeric column index, so inserting a column shifts the target and returns wrong data.
Which function pair lets you perform a horizontal lookup across a row of headers?
Answer: HLOOKUP
HLOOKUP searches across the top row and returns a value from a specified row beneath it.
What does the MATCH function return?
Answer: The relative position of a value within a range
MATCH returns the numeric position of a lookup value within a row or column.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy