INDEX
Returns a value or reference of the cell at the intersection of a particular row and column in a given range
Syntax
INDEX(array, row_num, [column_num]) or INDEX(reference, row_num, [column_num], [area_num])
Parameters
- array: Required. A range of cells or an array constant
- row_num: Required. The row in array from which to return a value
- column_num: Optional. The column in array from which to return a value
- area_num: Optional. Selects a range in reference from which to return the intersection of row_num and column_num
Example
=INDEX(A1:C5, 2, 3)