Microsoft Office Tutorials and References
In Depth Information
Syntax
22. Be sure to use exactly the same shape range as the first argument in
the INDEX function: =INDEX(F2:F89,WhichRow,WhichColumn) searches
through the customer names in column F.
33. For the second parameter of the INDEX function, specify the relative
row number. This information was provided by the MATCH function in
step 1.
44. Ensure that the third parameter of the INDEX function is the relative
column number. Because the range F2:F89 has only one column, this is
either 1 or can simply be omitted.
55. Putting the formula together, the formula in cell B2 is
=INDEX(F2:F89,MATCH(B1,H2:H89,0),1).
Syntax
INDEX(array,row_num,[column_num])
INDEX(reference,row_num,[column_num],[area_num])
The INDEX function returns the value at the intersection of a particular row
and column within a range. This function takes the following arguments:
array
array This is a range of cells or an array constant. If array
contains only one row or column, the corresponding row_numor
column_numargument is optional. If arrayhas more than one row and
more than one column, and if only row_numor column_numis used,
INDEX returns an array of the entire row or column in array.
row_num
row_num This selects the row in arrayfrom which to return a
value. If row_numis omitted, then column_numis required.
column_num
column_num This selects the column in arrayfrom which to return
a value. If column_numis omitted, then row_numis required.
If both the row_numand column_numarguments are used, INDEX returns the
value in the cell at the intersection of row_numand column_num.
If you set row_numor column_numto 0, INDEX returns the array of values
for the entire column or row, respectively. To use values returned as an ar-
ray, you use the INDEX function as an array formula in a horizontal range
of cells for a row and in a vertical range of cells for a column. To enter an
array formula, you press Ctrl+Shift+Enter.
row_numand column_nummust point to a cell within array; otherwise, INDEX
returns a #REF! error.
Search JabSto ::

Custom Search