Posted on

# MS Excel Index Function

Spread the love

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.  Syntax

=INDEX (array, row_num, [col_num], [area_num])

=INDEX (reference, row_num, [col_num], [area_num])

Arguments

• 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.  Explanation:

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).

Usage notes

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.  ## 1 thought on “MS Excel Index Function”

1. […] in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to […]