INDEX function in excel

This function picks a value from a range of data by looking down a specified number of rows and then across a specified number of columns. It can be used with a single block of data or non-continuous blocks.

Syntax
=INDEX(array,row_num,[col_num]
=INDEX(reference,row_num,[column_num],[area_num])
Arguments
array - A range of cells, or an array constant.
row_num - The row position in the reference or array.
col_num - [optional] The column position in the reference or array.
area_num - [optional] The range in reference that should be used.