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 XLOOKUP, which argument controls whether the search runs from first-to-last or last-to-first?
Answer: search_mode
The search_mode argument accepts values like 1, -1, 2, and -2 to set search direction and binary search.
How does INDEX(range, MATCH(...)) find the intersection of a row and column?
Answer: By using MATCH twice for row and column positions
A two-dimensional lookup uses INDEX with two MATCH calls, one for the row and one for the column.
What is the effect of setting XLOOKUP's match_mode to 2?
Answer: Wildcard character match
match_mode 2 enables wildcard matching using ? and * characters.
Which function returns multiple matching rows for a single criterion, unlike VLOOKUP which returns only the first?
Answer: FILTER
FILTER returns every row that meets the condition, not just the first match.
When VLOOKUP's range_lookup is TRUE, how must the first column be arranged for correct results?
Answer: Sorted in ascending order
Approximate-match VLOOKUP requires the lookup column sorted ascending, or it returns incorrect values.
What does the QUERY function use to retrieve lookup-style results from a dataset?
Answer: A SQL-like query language
QUERY uses a Google Visualization API query language similar to SQL for selecting and filtering data.
How can you make VLOOKUP work across an entire column without manually copying the formula down?
Answer: Wrap it in ARRAYFORMULA
ARRAYFORMULA lets a single VLOOKUP process an entire array of lookup values at once.
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