The Excel INDEX function returns the value at a given position in a range or array. You can use index to retrieve individual values or entire rows and columns. INDEX is often used with the MATCH function, where MATCH locates and feeds a position to INDEX.
=INDEX (array, row_num, [col_num], [area_num])
=INDEX (reference, row_num, [col_num], [area_num])
- array – A range of cells, or an array constant.
- row_num – The row position in the reference or array.
- col_num – [optional] The column position in the reference or array.
- area_num – [optional] The range in reference that should be used.
1.We want to know how much student 5 got In physics. So we first type index and select array (all the numbers).
2.Forrow_num we can give 5 or use match function (it is easier to use match function when the list is long).
3. For column_num we can give 4 or use match function (it is easier to use match function when there are many column).
Use the INDEX function to get a value from a list or table based on its location. For example, the formula =INDEX(A1:B5,2,2) will return the value at the address B2.
The INDEX function has two forms: array and reference.