| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill series formulas
This is my formula: =IF(ISERROR(INDEX('June-July
2007'!C5:D34,MATCH(B7,'June-July 2007'!D5:D34,0),1)), "0", INDEX('June-July 2007'!C5:D34,MATCH(B7,'June-July 2007'!D5:D34,0),1)) I am using a range of data which I want to stay the same every time I fill down, but Excel changes the range. How do I keep the range from not changing? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
fill series formulas
$C$5:$D$34
-- Don Guillett Microsoft MVP Excel SalesAid Software "Confused" wrote in message ... This is my formula: =IF(ISERROR(INDEX('June-July 2007'!C5:D34,MATCH(B7,'June-July 2007'!D5:D34,0),1)), "0", INDEX('June-July 2007'!C5:D34,MATCH(B7,'June-July 2007'!D5:D34,0),1)) I am using a range of data which I want to stay the same every time I fill down, but Excel changes the range. How do I keep the range from not changing? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
fill series formulas
Try this, your range should not change if you drag or copy your formula:
=IF(ISERROR(INDEX('June-July 2007'!$C$5:$D$34,MATCH(B7,'June-July 2007'!$D$5:$D$34,0),1)), "0", INDEX('June-July 2007'!$C$5:$D$34,MATCH(B7,'June-July 2007'!$D$5:$D$34,0),1)) -- Yanick "Confused" wrote: This is my formula: =IF(ISERROR(INDEX('June-July 2007'!C5:D34,MATCH(B7,'June-July 2007'!D5:D34,0),1)), "0", INDEX('June-July 2007'!C5:D34,MATCH(B7,'June-July 2007'!D5:D34,0),1)) I am using a range of data which I want to stay the same every time I fill down, but Excel changes the range. How do I keep the range from not changing? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| Fill series | New Users to Excel | |||
| Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| Fill Series | New Users to Excel | |||
Hybrid Mode
