← Back to level 2
Level 2Level 2
INDEX
Returns a value from a range using row and column positions.
Syntax
=INDEX(array, row_num, [column_num])Step-by-step explanation
- 1Reference the range you want to pull from.
- 2Set the row and optional column to control the return value.
- 3Pair it with MATCH for advanced lookups.
Common mistakes
Off-by-one row references
Using it without MATCH when positions are dynamic
Confusing array and reference syntax
Example table
A quick scenario to connect the syntax to the result.
| Sales | 120 |
| Support | 95 |
Formula
=INDEX(B1:B2,2)
Result
95
Practice area
Return the second value in the list.
Match against the syntax block above.