Jerry Feldman wrote:
On one sheet I have a monthly column of numbers where only the end of
the year is populated (for 50 years), as an example
A B
7/31/2007 0
8/31/2007 0
9/30/2007 0
10/31/2007 0
11/30/2007 0
12/31/2007 123.456
.
.
.
What I would like to do is to create another column that has 1 year for
each row:
X Y
12/31/2007 123.456 (=A6)
12/31/2008 456.678 (=A(6+12))
I'm not sure how to set up a formula is column Y that will reference
the end of year numbers.
My preference would be to simply use, assuming you start columns X and Y
in row 2, for example, Y2=vlookup(X2;$A$1:$B$999;2)
However,to more closely match what you have suggested you want to do,
you could use three columns, X, Y, and Z. Col X would contain the
December dates, as you have illustrated, Cell Z2 and Y2 would contain
the following entries: Z2 would read ="B"&TEXT(12*ROW(X2)-18;"###") and
Y2 would read =Indirect(Z2). Actually, you could eliminate column Z and
have Y2 read =Indirect("B"&TEXT(12*ROW(X2)-18;"###"))
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
