Does anyone know how to prevent a formula from advancing when you copy it down. My situation is this, I'm trying to use the VLookup function to pull data from a table. When I copy the formula down, it doesn't just advance the lookup value number, it also advances the table array. I do want the lookup value to advance of course, but not the table array. I want the table array to be the same all the way down. For example, the formula looks like this:

=VLOOKUP(B2,'September 2005'!A2:G296,1,FALSE)

When I copy it down it changes to:

=VLOOKUP(B3,'September 2005'!A3:G297,1,FALSE)

and the numbers A3:G297 keep advancing as I copy the formula down.

Like I said, I do want the B2 to advance to B3, but I do not want the A2:G296 to change when I copy the formula down. Is there a way to do this?