← Back to level 2
Level 2Next
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
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =INDEX(B1:B2,2) in the result cell and press Enter.
- 3Check that the output matches 95.
Practice area
Return the second value in the list.
Match against the syntax block above.