Hello again to all masters of microsoft!

I am having problems (again), i need to copy the formula below to alot of cells..... but i want the values in bold to increase by 1 when i copy, otherwise i'm having to change each one by hand, which is a pain!
I know there must be a way to do this, i've tried using the absolute column and relative row reference on the first value in the formula but it doesn't seem to work. As for the second value......well lets just say i'm stuck!

=IF('Lisa Flexi Input'!$D247=0,"",VLOOKUP(39569,'Lisa Flexi Input'!$A$126:$D$506,4,'Lisa Flexi Input'!$D$4:$D$506))

Any ideas, please make my life easier!!!

G