Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of nonadjacent selections, you can pick the selection to look in.
The INDEX function has two syntax forms: array and reference. The array form always returns a value or an array of values; the reference form always returns a reference.
Syntax 2
Reference form
INDEX(reference,row_num,column_num,area_num)
Reference is a reference to one or more cell ranges.
If you are entering a nonadjacent range for the reference, enclose reference in parentheses.
If each area in reference contains only one row or column, the row_num or column_num argument, respectively, is optional. For example, for a single row reference, use INDEX(reference,,column_num).
Row_num is the number of the row in reference from which to return a reference.
Column_num is the number of the column in reference from which to return a reference.
Area_num selects a range in reference from which to return the intersection of row_num and column_num. The first area selected or entered is numbered 1, the second is 2, and so on. If area_num is omitted, INDEX uses area 1.
For example, if reference describes the cells (A1:B4,D1:E4,G1:H4), then area_num 1 is the range A1:B4, area_num 2 is the range D1:E4, and area_num 3 is the range G1:H4.
Remarks
If you set row_num or column_num to 0 (zero), INDEX returns the reference for the entire column or row, respectively.
Example
The example may be easier to understand if you copy it to a blank worksheet.
Selecting an example from Help
|
|