variable cell reference

[bgc]

I have a column (J) of numbers, containing say 2,15,25 etc which I wish to use in another cell reference =M2 or M15 or M25 where the number reference is picked up from the contents of the cell in column J.
How do I do this?
Appreciate your help!
BGC

[vlady]

maybe
=INDIRECT("M"&J1)

[bgc]

Thanks for the suggestion. That works fine!
Of course you cant cut and paste this entry as cell addresses within the " " are not carried across and need to be edited by hand.
Regards
BGC

[vlady]

maybe this is what you want

=ADDRESS(J1,13)

13 is Column Header letter M

J1 -> get the value from j1 assuming 53

so the output would be $M$53 ->you can copy paste this...

or maybe
=LEFT(ADDRESS(1,13,4))&J1

[bgc]

This works as well:
=INDIRECT(ADDRESS($O496,13))
so content of cell determined by ADDRESS (Row element = $O496, Column 13 (M))

[Cutter]

Maybe just

=INDEX(M:M,$O496)

(has the advantage of being non-volatile)