INDEX function


DESCRIPTION:

Get a value in a list or table based on location.

 

SYNTAX:

=INDEX( array, row_num[column_num] )

 

REQUIRED ARGUMENTS:

array

A range of cell or an array of constants.

row_num

The row position in the reference.

 

OPTIONAL ARGUMENTS:

[column_num]

The row position in the reference.