Copy Formula Into Certainty Range

[muhammad susanto]

hi all..

how to copy down this formula to make it correct...

[COLOR=#333333]=VLOOKUP($N$2;'Input BGN'!$A:$BV;72;FALSE)[/COLOR]

i want to copy copy down that's formula into :
row L188
row L215
etc...

interval rows 27
i have trying INT((ROWS($1:41)-1)/27)..but i don't know use it...(combine)
how to fix it?

thanks in advance...

m.susanto

 

[muhammad susanto]

i found

[COLOR=#333333]=IF(Mod(Row()-134,27) = 0, Do formula, Do something else)[/COLOR]

[COLOR=#333333]the -134 takes row(161) and makes it 27[/COLOR]
[COLOR=#333333]row (188) becomes 54 (twice 27 so Mod(188 - 134, 27) = 0.[/COLOR]

but i don't know use & combine with =VLOOKUP($N$2;'Input BGN'!$A:$BV;72;FALSE)

hope someone would help me out..

 

[StephenCrump]

Try: =IF(MOD(ROW()-ROW(L$188),27),"",VLOOKUP($N$2,'Input BGN'!$A:$BV,72,FALSE))

(I haven't tried to adjust to use your ";' separators)