Thread: How to use number in some cell as a part of other cells reference?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How to use number in some cell as a part of other cells reference?
Try

=INDIRECT("C"&A1)

Mike

"Piia" wrote:

Hi,

How can I get number in some cell to the number of some other cells reference?

For example, if I have calculation in cell A1 giving some number XX and I
want to refer in cell B1 to cell CXX (column C, row XX), how do I do this?

Thanks and bye,
Piia
Reply With QuoteReply With Quote