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)
