INDEX Function in Excel: Syntax, Examples and Free Practice
INDEX is an Excel Lookup & Reference function. Returns the value at a given row/column position within a range.
INDEX syntax
Arguments
array: The range to pull fromrow_num: Which row within the rangecolumn_num: Which column within the range (optional for single-column ranges)
When to use INDEX
Pulling the Nth item from a list — often paired with MATCH to look up in any direction.
Practice INDEX online, free
Solve graded INDEX practice questions in a live Excel-style spreadsheet and check your answer instantly.
Practice INDEX now →Learn more
Read the tutorial: How to use INDEX and MATCH.
INDEX practice questions
- Using INDEX, return the third item name from the list and put it in D2.
- Return the price of the fourth product in the list and put it in D2.
- Using INDEX, return the units for the second department in the third quarter and put it…
- The position number is typed in E2. Return the name at that position from the list and…
- Using INDEX with COUNTA, return the most recent (last filled) log entry and put it in…
- The row and column positions are typed in E2 and F2. Return the matching value from the…
- Using INDEX with ROWS, return the second-last name in the list and put it in D2.
- The From and To positions are typed in D2 and E2. Find the revenue growth (revenue at To…
- Using INDEX with MOD, return the weekday name for the day number typed in D2 and put it…
- Find the value in the last row and last column of the Q1 to Q3 table without counting by…
- Employees are in A2:C7 (name, ID, department). Employee IDs to find are in E2:E5. Show…
- Monthly unit sales are in A1:E5 (products down, months across). Find the sales of Tablet…
- Names are in A2:A8 and sales in B2:B8. Show the name of the salesperson with the highest…
More Lookup & Reference functions
Frequently asked questions
What does the INDEX function do in Excel?
Returns the value at a given row/column position within a range.
What is the syntax of INDEX in Excel?
The syntax is =INDEX(array, row_num, [column_num]). array: The range to pull from; row_num: Which row within the range; column_num: Which column within the range (optional for single-column ranges).
Where can I practice INDEX online for free?
Open the free live spreadsheet on Cellgrids and try INDEX yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts