IntermediateLookup & Reference
Find a value with INDEX and MATCH
Combine INDEX and MATCH to look up a value without a fixed column number.
INDEX · MATCH
10 min25 points
MATCH
Returns the position of a value within a range.
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Lookup & Reference.
A worked example
=MATCH("Alan Reyes",F2:F5,0)
Returns 3
Returns the position of the name within the list.
Where it goes wrong
Omitting the final 0 defaults to approximate match on sorted data. On an unsorted list that returns the wrong position without warning.
Practise MATCH
Knowing what a function does and being able to write it from memory are different skills. These close the gap.