INDEX function

description:

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

 

syntax:

=INDEX( arrayrow_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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.