EXCEL INDEX

The INDEX function is used to return a value from within a specified range of cells based on its row and column numbers.

Syntax:

=Index(array,row_num,[column_num])

Arguments or Parameters:

array: a range of cells or an array.
row_num: The row position in the reference or an array.
[column_num] [optional] :The column position in the reference or an array.

Objective: Find the Week1 value of the S5 function in cell k4.

Step 1:

Type = sign in cell K4.
Type Index function

Step 2:

Select range C3:G18.
Type “,”

Step 3:

Type 6 in row_num argument
Type “,”
Type 2 in column_num argument
Close formula brack with “)”
Press Enter.

Conclusion: The index function has populated the Week1 value of the S5 function in cell k4.