I will begin by saying that although I have used Calc for several years, I am still a novice when trying to do more than just basic things.I tried searching here for a solution, but didn't find it. I am trying use the fill option so that the formula will read; =IF(C2=D1;A2;0) =IF(C2=E1;A2;0) =IF(C2=F1;A2;0) =IF(C2=G1;A2;0) etc.

Everything I have tried always comes out with; =IF(C2=D1;A2;0) =IF(D2=E1;B2;0) =IF(E2=F1;C2;0) =IF(F2=G1;D2;0) etc

Is there a solution to make this work?