Thread: Cell Location Reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_4_] Sheeloo[_4_] is offline
external usenet poster
  
Posts: 225
Default Cell Location Reference
Use in any cell other than C7 or R2
=Indirect(R2)

"Roy A." wrote:

I have a cell R2 which shows "C7" as its value. I would like to reference R2
in a formula and obtain the value in cell C7. Is this possible?

Reply With QuoteReply With Quote