Cell Referencing between multiple worksheets
To reference a cell in the range B1-B12 of Sheet2, based on the value (1-12)
in C1 use
=INDIRECT("Sheet2!B"&C1)
so if C1 has 5 you will get the value in B5
"Nelson B." wrote:
I need some help on a problem I have. In excel 2007 I want to make cell A1
equal the value of cell B1, which is on a different worksheet. However, I
want cell A1 to change which cell it references based on what month it is.
For example, if it is January, I want cell A1 to reference cell B. However,
if it is February I want it to reference cell B2. I already have a cell, C1,
where I put in the number corresponding with what month it is that I
reference for other formulas. Any ideas?
Thanks!
|