INDEX practice

INDEX returns the value at a given row and column position in a range. Below are the 5 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

INDEX(range, row, [column])

What people get wrong

Paired with MATCH it looks up to the left and in two directions, which VLOOKUP cannot do.

Google Sheets exercises that use INDEX

• INDEX and MATCHLevel 3Pro
• Row and column lookupLevel 3Pro
• Best seller with SORTLevel 4Pro
• Top region with QUERYLevel 4Pro
• First name with SPLITLevel 5Pro

Often used together with: MATCH, QUERY, SORT, SPLIT