Lookup Reference Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Lookup Reference Functions
  4. INDEX Uses an index to choose a value from a reference or array
=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.