Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=INDEX((A1

Input the formula: =INDEX((A1:C6,A8:C11),2,2,2). Press Enter to get the result.