Lookup & Reference
All versions
◉ 2 views
=INDEX()
Returns the value at a specific position in a range
=INDEX(array, row_num, [column_num])
Hover argument names in the table for details.
Output typeMixed
Popularity95 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =INDEX() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
array |
Range | Required | Range |
row_num |
Number | Required | Row number |
column_num |
Number | Optional | Column number |
▣ Examples
Example 1
=INDEX(C2:C100, 5)
Example 2
=INDEX(C2:C100, MATCH(E2, A2:A100, 0))
✦ Tips
- If the range has only one column or one row, a single number is enough.
- If the row number is zero, the whole column is returned.
- A number larger than the range size gives the #REF! error.
⚠ Common Errors
#REF!
The row or column number is larger than the range size
Fix: Check the numbers and the range size
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!