View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default 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