If there is a row that has the year in each column:
2001 2002 2003 2004
and I label this row "Year";
I then have a row named "EBIT"
with values in the corresponding years
500 600 800 400
Dep&Am the same way:
100 200 150 260
Is there a way to name say:
EBITDA01 = EBIT01+DepAm01
EBITDA02 = EBIT02+DepAm02
My purpose in doing this is that the years will change frequently.
Basically, I just want to be able to name the rows and have the year "lookup" the corersponding row/value. Thanks for your help.
2001 2002 2003 2004
and I label this row "Year";
I then have a row named "EBIT"
with values in the corresponding years
500 600 800 400
Dep&Am the same way:
100 200 150 260
Is there a way to name say:
EBITDA01 = EBIT01+DepAm01
EBITDA02 = EBIT02+DepAm02
My purpose in doing this is that the years will change frequently.
Basically, I just want to be able to name the rows and have the year "lookup" the corersponding row/value. Thanks for your help.