Autofill in large formulas

[samz91]

hi,

You know when you can autofill numbers down or across cells but just typing in the first few, well i need that in my formulas...let me explain

i have a formula in cell A3 that looks at a date in cell A1 and adds 7 to it. So A4 should add 14, A5 should 21 etc....its a weekly calculation.

my actual formula is: =VLOOKUP($A$1+7),'_Finance 2013 MID.xlsx'!Dates,1,0)

inside A1 is simple 8-8-13...a date

thank you

[Richard Buttrey]

Hi,

Not exactly sure what you're asking but leave out the second parentheses and try

=VLOOKUP($A$1+7,'_Finance 2013 MID.xlsx'!Dates,1,0)

Otherwise upload your workbook and manually add some results explaining how you arrived at them so that we can construct a formula.

[Pete_UK]

Change it to this:

=VLOOKUP($A$1+7*ROWS($1:1),'_Finance 2013 MID.xlsx'!Dates,1,0)

then copy down.

Alternatively, put this formula in A4:

=A3+7

and copy that down to get consecutive weekly dates.

Hope this helps.

Pete

[samz91]

pete u genius!!

thank you both