Increasing Month only in formula

[Malla]

Kindly i need help on below:

i have a formula as "=Jan!G$2" in Cell "A1", i'm looking to have "=Feb!G$2"
in Cell "A2" and "=Mar!G$2" in Cell "A3" and so on by simple dragging.
is that possible?

 

[Ron Rosenfeld]

Kindly i need help on below:

i have a formula as "=Jan!G$2" in Cell "A1", i'm looking to have "=Feb!G$2"
in Cell "A2" and "=Mar!G$2" in Cell "A3" and so on by simple dragging.
is that possible?

If I understand you correctly, try:

A1: =INDIRECT(ADDRESS(2,7,2,,TEXT(DATE(,COLUMNS($A:A),1),"mmm")))

and drag right to L1

--ron

 

[Jim Thomlinson]

Yes and no. You will have to add a helper column with Jan, Feb, Mar, ... in
the cells.
Assuming that is in Cell B2, B3, ... then in A2 use the formula

=indirect(b2 & "!G2")
And drag down. Note that this formulas has a surprising amount of overhead
to it so if you have thousands of these you will notice taht you spread sheet
calculates slowly.

 

[Ron Rosenfeld]

If I understand you correctly, try:

A1: =INDIRECT(ADDRESS(2,7,2,,TEXT(DATE(,COLUMNS($A:A),1),"mmm")))

and drag right to L1

--ron

Sorry, I first thought you were filling columns.

Make this change:

=INDIRECT(ADDRESS(2,7,2,,TEXT(DATE(,rowS($1:1),1),"mmm")))

then fill down to A12.
--ron

 

[T. Valko]

Try this...

=INDIRECT(TEXT(ROWS(A$1:A1)*29,"mmm")&"!G2")

Copy down as needed.