=INDEX(Sheet1!A1:J10,5,5)
returns contents from 5th row 5th column of array Sheet1!A1:J10

If this post helps click Yes
---------------
Jacob Skaria


"Drew" wrote:

I am trying to write a formula that will return the results of a cell based
on cell coordinates (including sheet where located and cell within that sheet
(column and row)). Is anyone aware of how to do this?

Thanks,
--
Drew