|
Using IF function then Autofill-increments down a reference cell
After creating an IF function, when I attempt to autofill, the corresponding
filled cell increments the reference cell. Example: Original cell =IF(B2=Overstreet!C7,Overstreet!D7)+IF(B2:B495=Ove rstreet!C8,Overstreet!D8)+IF(B2:B495=Overstreet!C9 ,Overstreet!D9)+IF(B2:B495=Overstreet!C10,Overstre et!D10)+IF(B2:B495=Overstreet!D11,Overstreet!D11)+ IF(B2:B495=Overstreet!C12,Overstreet!D12)+IF(B2:B4 95=Overstreet!C13,Overstreet!D14)+IF(B2:B495=Overs treet!C15,Overstreet!D15)+IF(B2:B495=Overstreet!C1 6,Overstreet!D16) First autofilled cell =IF(B3=Overstreet!C8,Overstreet!D8)+IF(B3:B496=Ove rstreet!C9,Overstreet!D9)+IF(B3:B496=Overstreet!C1 0,Overstreet!D10)+IF(B3:B496=Overstreet!C11,Overst reet!D11)+IF(B3:B496=Overstreet!D12,Overstreet!D12 )+IF(B3:B496=Overstreet!C13,Overstreet!D13)+IF(B3: B496=Overstreet!C14,Overstreet!D15)+IF(B3:B496=Ove rstreet!C16,Overstreet!D16)+IF(B3:B496=Overstreet! C17,Overstreet!D17) Second =IF(B4=Overstreet!C9,Overstreet!D9)+IF(B4:B497=Ove rstreet!C10,Overstreet!D10)+IF(B4:B497=Overstreet! C11,Overstreet!D11)+IF(B4:B497=Overstreet!C12,Over street!D12)+IF(B4:B497=Overstreet!D13,Overstreet!D 13)+IF(B4:B497=Overstreet!C14,Overstreet!D14)+IF(B 4:B497=Overstreet!C15,Overstreet!D16)+IF(B4:B497=O verstreet!C17,Overstreet!D17)+IF(B4:B497=Overstree t!C18,Overstreet!D18) And so on. Any suggestions? -- Mark |
Using IF function then Autofill-increments down a reference cell
Hi,
Make your cell reference absolute.. For example if your cell reference is B2 make it $B$2. Hope this helps, Gav. "Twinspot" wrote: After creating an IF function, when I attempt to autofill, the corresponding filled cell increments the reference cell. Example: Original cell =IF(B2=Overstreet!C7,Overstreet!D7)+IF(B2:B495=Ove rstreet!C8,Overstreet!D8)+IF(B2:B495=Overstreet!C9 ,Overstreet!D9)+IF(B2:B495=Overstreet!C10,Overstre et!D10)+IF(B2:B495=Overstreet!D11,Overstreet!D11)+ IF(B2:B495=Overstreet!C12,Overstreet!D12)+IF(B2:B4 95=Overstreet!C13,Overstreet!D14)+IF(B2:B495=Overs treet!C15,Overstreet!D15)+IF(B2:B495=Overstreet!C1 6,Overstreet!D16) First autofilled cell =IF(B3=Overstreet!C8,Overstreet!D8)+IF(B3:B496=Ove rstreet!C9,Overstreet!D9)+IF(B3:B496=Overstreet!C1 0,Overstreet!D10)+IF(B3:B496=Overstreet!C11,Overst reet!D11)+IF(B3:B496=Overstreet!D12,Overstreet!D12 )+IF(B3:B496=Overstreet!C13,Overstreet!D13)+IF(B3: B496=Overstreet!C14,Overstreet!D15)+IF(B3:B496=Ove rstreet!C16,Overstreet!D16)+IF(B3:B496=Overstreet! C17,Overstreet!D17) Second =IF(B4=Overstreet!C9,Overstreet!D9)+IF(B4:B497=Ove rstreet!C10,Overstreet!D10)+IF(B4:B497=Overstreet! C11,Overstreet!D11)+IF(B4:B497=Overstreet!C12,Over street!D12)+IF(B4:B497=Overstreet!D13,Overstreet!D 13)+IF(B4:B497=Overstreet!C14,Overstreet!D14)+IF(B 4:B497=Overstreet!C15,Overstreet!D16)+IF(B4:B497=O verstreet!C17,Overstreet!D17)+IF(B4:B497=Overstree t!C18,Overstreet!D18) And so on. Any suggestions? -- Mark |
Using IF function then Autofill-increments down a reference ce
Thanks Gav,
That solved my issue. -- Mark "Gav123" wrote: Hi, Make your cell reference absolute.. For example if your cell reference is B2 make it $B$2. Hope this helps, Gav. "Twinspot" wrote: After creating an IF function, when I attempt to autofill, the corresponding filled cell increments the reference cell. Example: Original cell =IF(B2=Overstreet!C7,Overstreet!D7)+IF(B2:B495=Ove rstreet!C8,Overstreet!D8)+IF(B2:B495=Overstreet!C9 ,Overstreet!D9)+IF(B2:B495=Overstreet!C10,Overstre et!D10)+IF(B2:B495=Overstreet!D11,Overstreet!D11)+ IF(B2:B495=Overstreet!C12,Overstreet!D12)+IF(B2:B4 95=Overstreet!C13,Overstreet!D14)+IF(B2:B495=Overs treet!C15,Overstreet!D15)+IF(B2:B495=Overstreet!C1 6,Overstreet!D16) First autofilled cell =IF(B3=Overstreet!C8,Overstreet!D8)+IF(B3:B496=Ove rstreet!C9,Overstreet!D9)+IF(B3:B496=Overstreet!C1 0,Overstreet!D10)+IF(B3:B496=Overstreet!C11,Overst reet!D11)+IF(B3:B496=Overstreet!D12,Overstreet!D12 )+IF(B3:B496=Overstreet!C13,Overstreet!D13)+IF(B3: B496=Overstreet!C14,Overstreet!D15)+IF(B3:B496=Ove rstreet!C16,Overstreet!D16)+IF(B3:B496=Overstreet! C17,Overstreet!D17) Second =IF(B4=Overstreet!C9,Overstreet!D9)+IF(B4:B497=Ove rstreet!C10,Overstreet!D10)+IF(B4:B497=Overstreet! C11,Overstreet!D11)+IF(B4:B497=Overstreet!C12,Over street!D12)+IF(B4:B497=Overstreet!D13,Overstreet!D 13)+IF(B4:B497=Overstreet!C14,Overstreet!D14)+IF(B 4:B497=Overstreet!C15,Overstreet!D16)+IF(B4:B497=O verstreet!C17,Overstreet!D17)+IF(B4:B497=Overstree t!C18,Overstreet!D18) And so on. Any suggestions? -- Mark |
| All times are GMT +1. The time now is 11:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com