INDEX()
Syntax (Array Version). INDEX(array,row_num,column_num)
Syntax (Reference Version). INDEX(reference,row_num,column_num,area_num)
Definition. This function uses a row and/or column index to select one or more values from an array (multiple connected cells or expressions separated by a semicolon and enclosed in braces) or from a reference (which can contain one or more references to rectangular areas) based on index entries.
Arguments (Array Version)
array (required). Must be a range of cells or an array constant.
row_num (optional). Can be omitted if the array argument includes only one cell. This argument must evaluate to a positive integer and specifies the number of the row that holds the values to work with.
column_num (optional). An expression ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
