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

return a value from a specified table position. Use INDEX to Returns value from array by row/column position. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use 2 for row_num. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=INDEX(D2:D8, 2)

Practice This Function

Practice in Sequential Mode Back to Function List