fill series formulas

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

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!
 
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))
 
Back
Top