Alternative to dragging down my formula every day

[kylerisi]

Hi Team

I have a V lookup formula that I use everyday, the trouble is that Each time I update my source data I have to keep dragging down my formula against the new values on my sheet,

Is there a way that i can not have to do this every day?

Here is my formula that I am currently using

=vlookup(OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-4),'Walkthru List'!G:H,2,false)

I have another formula that I use which automatically applies the following formula to all NON BLANK cells

=ArrayFormula('WalkThru Log'!A:G)

is it possible to use this same method for my Vlookup?

Any help will be greatly appreciated

Kyle

 

[kylerisi]

Hi Team

I have a V lookup formula that I use everyday, the trouble is that Each time I update my source data I have to keep dragging down my formula against the new values on my sheet,

Is there a way that i can not have to do this every day?

Here is my formula that I am currently using

=vlookup(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),0,-4),'Walkthru List'!G:H,2,false)

I have another formula that I use which automatically applies the following formula to all NON BLANK cells

=ArrayFormula('WalkThru Log'!A:G)

is it possible to use this same method for my Vlookup?

Any help will be greatly appreciated

Kyle

I found a solution, Thank you

=ARRAYFORMULA(VLOOKUP(D2:D,'Walkthru List'!G2:H,2*SIGN(ROW(D2:D)),FALSE))