hi-liting one cell changes another cell

[juan1]

I would like to have cell C50 (presently shows the letter A in it, representing a dimension) to show the value of another cell that I click from (would be from locked cells F4:Z4), not actually change it.

I would then do this for other typical areas for other dimensions.

thanks for any help
Juan

 

[juan1]

ok thanks, I was trying not to be too confusing at first.

many thanks
Juan

 

[Joe4]

I was trying not to be too confusing at first.

Yes, and now you see why that sometimes can be dangerous, as if you oversimplify it, you may get an oversimplified answer that won't work for your actual situation.
It is usually best to be upfront regarding the full scope of the question, so we don't lead unknowingly lead you down a dead-end (and waste lots of time on solutions that won't work for you).