Monday, 13 August 2012

INDEX Function Syntax and Example

INDEX Function
The index function returns the index value ,  the value which is at the intersection of specified row and column.

Syntax:

=INDEX(ARRAY,ROWNO,COLNO)

Here:

>> ARRAY is the range of data you specified.
>> ROW NO is the row number.
>> COLNO  is the column number.

Example :



Thanks,
TAMATAM

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts