How to use Index Function (Formula) In Excel

INDEX

Use of Index Function / Formula In Excel

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.

Syntax / Formula of Index Function

The Syntax of Index function in Microsoft Excel is below

=INDEX(array, row_num, [column_num])

Example of INDEX Function in Excel

In below example we need 9th number Student name

Step 1: First created below table in your excel starting from position C1:F11

Step 2: Type formula =INDEX(D2:F11,9,2) in cell A2 and press enter.
             In this formula array (students name list) is D2:F11, row_num is 9 and column_no is 2.

INDEX FUNCTION