Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=INDEX({1,2;3,4},0,2) returns the value in the first row, second column in the array constant

Input the formula: =INDEX({1,2;3,4},0,2). Press Enter to get the result.