Articles → EXCEL FORMULA → Index Function In Excel

Index Function In Excel






What Is An Index?




Picture showing the index of a restaurant menu

Click to Enlarge



  1. Second item in the sweet dish section
  2. See the item in the second row and second column of the menu.



Purpose Of Index Function





Syntax


=Index(array, row_number, col_number)




  1. Array – collection of objects.
  2. Row_number – As the name suggests, this parameter represents row number in the collection.
  3. col_number – As the name suggests, this parameter represents column number in the collection.

Example


Picture showing the output of Index function in excel

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Saturday, January 7, 2017

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250