finding a cell from numerical coordinates
On Wed, 8 Jul 2009 13:38:01 -0700, Chip
wrote:
I am given coordinates like 10,100 and 125,200 - is there a way to tell Excel
to find the corresponding cell? Can I change the top row letters to numbers?
Try this
=OFFSET(A1, 10-1, 100-1)
and
=OFFSET(A1, 125-1, 200-1)
or, in general
=OFFSET(A1, x-1, y-1)
where x and y are your coordinates.
Hope this helps / Lars-Åke
|