Notice: WC_Cart::get_cart_url is deprecated since version 2.5! Use wc_get_cart_url instead. in /home/swatipaliwal/public_html/excelcrazy.com/wp-includes/functions.php on line 3839
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 - 2017

Reporting Solutions | Data Consulting | Analytics Training