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!

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!

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!