not urgent

Gary's Student · May 11, 2005

What function returns the contents of a cell given the row and column number?
For example, =DesiredFunction(10,10) should return the contents of J10

JE McGimpsey · May 11, 2005

One way:

=INDEX(1:65536,10,10)

bj · May 11, 2005

try
=index(A1,10,10)

N Harkawat · May 11, 2005

=INDIRECT(ADDRESS(10,10))

JE McGimpsey · May 11, 2005

Did you try your suggestion?

That will result in a #REF! error. The indexed cell must be within the
reference, so

=INDEX(1:65536,10,10)

will work.

bj · May 11, 2005

It would have been nice if I have written "offset" in the response like I did
in my worksheet when I tested it.

Thanks for catching it.

Gary's Student · May 11, 2005

Thank you all very much. I can now get rid of my user defined function and
use something standard.

Harlan Grove · May 11, 2005

N Harkawat wrote...

=INDIRECT(ADDRESS(10,10))

....

Yeah, but

=INDIRECT("R"&10&"C"&10,0)

saves a function call.