Excel Crazy

How to use Index Function in Excel

Index Function: Index function returns the value from the specific position in a table or range.

Syntax of Index Function

=Index(array, row_num, [column_num])

array = Range of cells or table.

row_num = The number of rows in the array to return the value.

[column_num] = Column number is optional. The number of columns in the table to return the value.

In the above screen shot, Index Function in Cell F2 would return
=Index(B4:F4,3,3) – “Anshul Gupta”(Would return the cell D6 value)

July 25, 2013

0 responses on "How to use Index Function in Excel"

Leave a Message

Your email address will not be published. Required fields are marked *

top
 

© LOKESH PALIWAL 1987 - 2018

LOKESH@EXCELCRAZY[DOT]COM | 8826547882

Reporting Solutions | Data Consulting | Analytics Training

CONTACT US
close slider

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Message for us...

Skip to toolbar