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

Picture showing the output of Index function in excel
Click to Enlarge

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