Using Cell Address in a Formula

[ananthusatheesh89]

Hi All,

I have created a formula in cell A1 to return the CELL ADDRESS of another cell, say M13. So now my cell A1 will have $M$13 in it. Now, this is where my trouble start...
I want to create a formula in A2=A1, But what I want is really the value in cell M13 and not $M$13. Is this possible...?? Sorry if the question is confusing. Please let me know if I can provide more details.

Thanks...

 

[VoG]

Try


=INDIRECT(A1)

 

[ananthusatheesh89]

Thanks... this is working..
Please help me with one more thing..
I give the formula in A2 =INDIRECT(A1).. which returns the value in M13, but actually I want the value in the cell which is two rows below M13. i.e. M15... is there any formula for this..?

Thank you once again...

 

[VoG]

Try

=OFFSET(INDIRECT(A1),2,0)

 

[ananthusatheesh89]

Thank you so much.. you are superb...