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. |