$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!