Excel Function

INDEX

Returns value from array by row/column position.

INDEX(array, row_num, [column_num])

Arguments

array

Required

Specify a reference range. You can drag or click start/end cells.

row_num

Required

Enter a numeric value.

column_num

Optional

Enter a numeric value.

Practice Preview

Use INDEX to return the result with these settings (Target range: D2:D8 (Stock in column D), Row number: 2). You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#	AProduct ID	BProduct Name	CPrice	DStock
2	P001	Apple	120	80
3	P002	Banana	98	120
4	P003	Notebook	450	35
5	P004	Pen	300	60
6	P005	Grapes	150	45
7	P006	Ruler	250	20
8	P007	Peach	86	55

How to Use (Formula)

=INDEX(D2:D8, 2)

Result

120

Practice This Function

Start Function Practice Back to Function List

INDEX FAQ

How do I use INDEX in Excel?

Use INDEX when you want to return a value from a row and column position. Enter Target range, Row number, Column number in that order, then add optional arguments when needed.

Where can I practice INDEX?

Use the "Start Function Practice" button to jump straight into INDEX drills.

What arguments does INDEX use?

The main arguments are Target range, Row number, Column number. Start with the required ones, then add optional arguments if needed.