Excel, how to get a value of a cell according is coordinates, like X,Y

You may wonder, why CELL formula in Excel didn't used to return a value of Cellaccording its coordinates? Well CELL formula is used to return some Properties of a referenced cell, see the help about the CELL formula.

What if you want to the a value of a cell according is coordinates, like X,Y or in Excel's worlds Column,Row number. INDEX is named the formula that can do this! It used for other purposes also, I demonstrate it for the thing we want to do.

syntax:
=INDEX(<array where will take place>;<row number>;<column number>)

example:
get the the x=1 and y=10,
with other words: the the value of the 10th row of the 1st row:
=INDEX(A:Z;10;1)

The A:Z means all the columns and row from the column A to column Z; you may define more specific are like:
=INDEX(B1:C30;10;1)
In this case, the 10th row of the 1st row will be applied in the are B1:C30.