Mega Code Archive

 
Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions
 

=INDEX(B1

Input the formula: =INDEX(B1:C4,2,1). Press Enter to get the result.