Fill Handle Problems (fill data from 2 rows)

Hey,

my last problem got solved with this Forum so I'll try my luck again. I'm working on a sheet for my university. Everything is working fine now, but i cant use the fill handle/ fill data option of Excel the way i want to.

=INDEX(INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3165+4*(SPALTE(A1)-1))&":"&ADRESSE(384;3165+4*(SPALTE(A1)-1)));VERGLEICH($A12;INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3164+4*(SPALTE(A1)-1))&":"&ADRESSE(384;3164+4*(SPALTE(A1)-1)));0))

This would be my first column. In the second Column I need some other ours but on the same day. I just realised ours are sometimes split. So the formula for the second row would look something like this:

=INDEX(INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3165+4*(SPALTE(B1)-1))&":"&ADRESSE(384;3165+4*(SPALTE(A1)-1)));VERGLEICH($A12;INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3164+4*(SPALTE(B1)-1))&":"&ADRESSE(384;3164+4*(SPALTE(A1)-1)));0))

So the A1 needs to change to B1 and it does if i only pull one row. If i start pulling two rows it changes to C1 immediatly. Why? and how do i get excel to do what i want :D.


Any suggestions?

thx for any help
Joel