finding a cell from numerical coordinates

[Chip]

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?

 

[Lars-Åke Aspelin]

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

 

[Shane Devenshire]

Hi,

Choose Tools, Options, General tab, R1C1 reference style

 

[T. Valko]

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?