copy/pasting formular

copy/pasting formular

I'm having a problem copy pasting this formula (Q2:AA2 on the DATA sheet)

IF(ISERROR(FIND(NAVN;C1;P2+LEN(NAVN)));"";FIND(NAVN;C1;P2+LEN(NAVN))) (cell Q2)

IF(ISERROR(FIND(NAVN;C2;P3+LEN(NAVN)));"";FIND(NAVN; C1;P3+LEN(NAVN))) ( cell Q3)

somehow the reference to C1 will not be changed to C2 if there is no error (and why isn't there an IFERROR command?)