Index Worksheet Function

by Linda Quinn

Close Window

SYNTAX:
=Index( Range, Row_num, [Column_num])


Range Range of cells in which the row number and column number can be found.
Row_Num The row number is relative to the range.
For example, if the range is B5:B10 then row_num 3 would be row 7
Column_Num If the Range is wider than a single column, the column number finds the correct column for the given row.


excel


In the above example, the first INDEX formula references the range A2:A7.
It has a row number of 4.
The fourth row in the range A2:A7 is row 5 of the Excel sheet, which contains the value 530.

The second INDEX example references the range A2:D7.
Since this range has 2 dimensions, we need to provide a column number in addition to a row number.
In this example the row is 5 and the column is 4. This is the location D6 in the range, which is the value 29,500.


excel










=================================================================
This content was created by Linda Quinn of LQNet.

See http://www.lqnet.com for a great collection of articles on this and other topics.

=================================================================
Copyright © 2006-2008, LQ Systems,Inc. All rights reserved.


====================================================================
Want an expert to help with your project?    LQ Systems, Inc.   Business Solutions
====================================================================