idex function

[Apriel]

I am trying to using the reference option of the index
function, but it keeps returning the contents rather than
the reference.

 

[Peo Sjoblom]

Use it with cell to get the address

=CELL("address",INDEX(MyRange,1,2))