| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill based on a cell reference | Excel Worksheet Functions | |||
| reference autofill. | Excel Worksheet Functions | |||
| Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
| Autofill/Reference Confusion | Excel Worksheet Functions | |||
| increase a cell reference by increments greater than one... | Excel Worksheet Functions | |||
Hybrid Mode
