Thread: Variable Cell Reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default Variable Cell Reference
or:
="C"&B1

"Sean Timmons" wrote:

=concatenate("C",B1)

"Andrew" wrote:

In A1 I want to show the value of cell Cx where x is a variable held in B1
eg.

B1= 5
A1 should show the value of C5

How can I do it please/

TIA
Andy





Reply With QuoteReply With Quote