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!