Skip to content
TechnoLearnAcademy
TECHNOLEARN
Menu
Home
About us
Trainer
Contact us
Fee
Login
Register
Home
Previous
Next
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.
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS SQL
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
Scroll to Top