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?

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

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?

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?