Thanks for your help!

"Sheeloo" wrote:

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!