idex function

Apriel · Oct 6, 2003

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

Peo Sjoblom · Oct 7, 2003

Use it with cell to get the address

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