Return cell value using the cell reference

[dmp3lic]

I am trying to return the value of a cell using the cell reference address.

For example, Cell N9 has a value of 75.
I have the location of that cell, ie "N9".
So I want a formula to return the actual contents or value of "N9" which would be 75.

 

[My Aswer Is This]

=N9

 

[dmp3lic]

sorry let me rephrase.
Cell K1 has the value "N9".
Cell N9 has the value of 75.
In Cell A1 i want a formula to reference the value in K1 (which would be "N9") and then return the value of that cell (which is really N9) so it returns "75".

 

[Fluff]

How about

=INDIRECT(K1)

 

[dmp3lic]

thank you again

 

[Fluff]

Glad we could help & thanks for the feedback.