Why you need this
Returns a value from a specific position in a list or table. Powerful when combined with MATCH.
One-Click Copy
=INDEX(array, row_num, [column_num])
Copy
Quick context
- • Works in both Excel and Google Sheets.
- • Use when you need consistent, auditable results.
- • Copy the snippet above and adjust only the ranges.
When to use
Learn how to use the Excel INDEX Formula.
Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.
Common Mistakes
- ✕ Row or Column number exceeds range. Requesting row 10 of a range that only has 5 rows will result in a #REF! error.
Best Practices
- ✓ Combine with MATCH. INDEX is rarely used alone. Combine it with MATCH or MATCH/XMATCH to dynamically find the row and column numbers.
Scalability Warning
Hardcoding indices (e.g., column 5) makes spreadsheets brittle.
See data Alternatives