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)