How to skip numbers with autocomplete?

[Psyshadow]

Hi everybody

I've already posted this in another thread, but to no avail..
My Formula is the following:

=IF(E6<2863;DGET('Eingangsprüfung alte Nr.'!$A$2:$C$400;3;R6:R7);DGET(Eingangsprüfung!$A$2:$C$60000;3;R6:R7))

If I use autofill now to complete a table with approx. 3000 entries, it autocompletes the red part to R7:R8, but I would like it to be R8:R9 and then R10:R11 and so on..

Any help here? Thanks in advance.​

 

[Andrew Poulsom]

On way is to use OFFSET(R$6,(ROWS(A$1:A1)-1)*2,0,2) in place of R6:R7.

 

[Psyshadow]

Works perfectly, thanks a lot.