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
INDEX
Returns the value at a given row and column position in a range.
Syntax
INDEX(array, row_num, [column_num])
Lookup & Reference.
A worked example
=INDEX(G2:G5,3)
Returns 3.5%
Returns the third value from the range.
Where it goes wrong
INDEX counts positions within the range you gave it, not spreadsheet row numbers. Position 3 of G2:G5 is G4.
Practise INDEX
Knowing what a function does and being able to write it from memory are different skills. These close the gap.