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
--
Gary's Student

One way:

=INDEX(1:65536,10,10)

In article ,
"Gary's Student" wrote:

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

try
=index(A1,10,10)

"Gary's Student" wrote:

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
--
Gary's Student

=INDIRECT(ADDRESS(10,10))

"Gary's Student" wrote in message
...
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
--
Gary's Student

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.




In article ,
"bj" wrote:

=index(A1,10,10)

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.

"JE McGimpsey" wrote:

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.




In article ,
"bj" wrote:

=index(A1,10,10)

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


"N Harkawat" wrote:

=INDIRECT(ADDRESS(10,10))

"Gary's Student" wrote in message
...
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
--
Gary's Student

N Harkawat wrote...
=INDIRECT(ADDRESS(10,10))
....

Yeah, but

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

saves a function call.