If column_num is omitted, row_num is required. Selects the column in array from which to return a value. If row_num is omitted, column_num is required.Ĭolumn_num Optional. Selects the row in array from which to return a value. Row_num Required, unless column_num is present. 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.
If array contains only one row or column, the corresponding row_num or column_num argument is optional. The array form of the INDEX function has the following arguments:Īrray Required. Use the array form if the first argument to INDEX is an array constant. Returns the value of an element in a table or an array, selected by the row and column number indexes. If you want to return a reference to specified cells, see Reference form. If you want to return the value of a specified cell or array of cells, see Array form.
There are two ways to use the INDEX function:
0 kommentar(er)
