Function INDEX

Parameters

• array: any

  A range of values or an array constant.

  • If array contains only one row or column, the corresponding row_num or column_num argument is optional.
  • If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array.
• row_num: any

  Required, unless column_num is present. Selects the row in array from which to return a value. If row_num is omitted, column_num is required.
• column_num: any

  Optional. Selects the column in array from which to return a value. If column_num is omitted, row_num is required.