# INDEX Uses an index to choose a value from a reference or array : INDEX « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial

```=INDEX(A1:C4,2,2) returns the value at the intersection of the second row and second column in the range.
```
```Input the formula: =INDEX(A1:C4,2,2). Press Enter to get the result.
```

 19.8.INDEX 19.8.1. INDEX Uses an index to choose a value from a reference or array 19.8.2. =INDEX(B1:C4,2,1) gets the value at the intersection of the second row and first column in the range 19.8.3. =INDEX({1,2;3,4},0,2) returns the value in the first row, second column in the array constant 19.8.4. =INDEX(A2:C6,2,3) gets the intersection of the second row and third column in the range A2:C6 19.8.5. =INDEX((A1:C6,A8:C11),2,2,2) gets the intersection of the second row and second column in the second area of A8:C11 19.8.6. =SUM(INDEX(A1:C11,0,3,1)) returns the sum of the third column in the first area of the range A1:C11 19.8.7. =SUM(B2:INDEX(A2:C6,5,2)) sums the range starting at B2 and ends at the intersection of the fifth row and the second column of the range A2:A6