not urgent

[Guest]

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]

One way:

=INDEX(1:65536,10,10)

 

[Guest]

try
=index(A1,10,10)

 

[N Harkawat]

=INDIRECT(ADDRESS(10,10))

 

[JE McGimpsey]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Harlan Grove]

N Harkawat wrote...

=INDIRECT(ADDRESS(10,10))

....

Yeah, but

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

saves a function call.