Look up absolute and relative references in help

Basically you need to prefix the row and columns with $ signs this fixes it.

=VLOOKUP(B3,'September 2005'!$A$3:$G$297,1,FALSE)

You can shorten this by pressing F4 when entering the formula

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"dallased25" wrote
in message ...

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?


--
dallased25
------------------------------------------------------------------------
dallased25's Profile:
http://www.excelforum.com/member.php...o&userid=28544
View this thread: http://www.excelforum.com/showthread...hreadid=482033