Based on work by Ady and Steve Fanning and others. This page was last edited 17:40, 17 April 2023 by Ilmari Lauhakangas.Typo in INDEX() description for one-dimensional row vector Equivalent Excel functions: The CELL function then returns the absolute address of cell B3. The INDEX function returns the reference to cell B3. Organized in one column of two rows: from the second line, return the first value from the first line, return the first value. An inline array (for example, is a 3-columns by 2-rows inline array, using semicolon as row-separator and comma as column-separator.
Named ranges defined using Sheet ▸ Named Ranges and Expressions ▸ Define on the Menu bar can be configured to comprise multiple areas by using the tilde reference concatenation operator in the Range or formula expression field of the Define Name dialog.
Alternatively, you can use the tilde reference concatenation operator directly without parentheses – for example =INDEX(A1:B6~C2:D7~E3:F8 …). In this case Calc will reformat your function call to use the tilde reference concatenation operator – for example =INDEX( (A1:B6~C2:D7~E3:F8 ) …). Multiple cell ranges can be passed as a single argument by providing them in a separated list, surrounded by parentheses – for example, =INDEX( (A1:B6 C2:D7 E3:F8 ) …).A single cell range (for example, A1:E10).Reference is a reference list specifying the range(s) of cells occupied by the input data table(s). However, depending on the formula used, the returned value may be used as a data value (whose type is determined by the input data set) or as a cell reference. Technically, INDEX returns a cell reference. In the special case when the first argument has only a single row, the following alternative syntax can be used: In the special case when the first argument has only a single column, the following simplified syntax can be used:
The general syntax for the INDEX function is: INDEX is a powerful function that can be utilized to look up values in multiple, non-contiguous cell ranges and can be used in an array context to return multiple values.įlexibility is increased when INDEX is used in conjunction with the MATCH function, enabling formulas to better react to changes in the input data. In its simplest form, INDEX can be used to retrieve the value in a particular cell, specified by relative row and column numbers within a data table.ĭepending on context, INDEX can also be used to determine the reference of the cell at the intersection of the specified row and column.
0 kommentar(er)
