finding a cell from numerical coordinates
 

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?

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

finding a cell from numerical coordinates
 

Hi,

Choose Tools, Options, General tab, R1C1 reference style

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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?

finding a cell from numerical coordinates
 

What exactly does "find the corresponding cell" mean?

Do you want that cells address?

Do you want to return the contents of that cell?

I am given coordinates like 10,100

Is that row 10 column 100 or column 10 row 100?

--
Biff
Microsoft Excel MVP


"Chip" wrote in message
...
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?