Disable Range Reference Update in Vlookup
 

I have some data that I update every week. I use a macro to update
this data. The macro moves the old data down one row and copies the
new data from various places and pastes it to the top row of my table.
On some other sheets I have vlookups that reference this table. Each
time that I run my macro to update my table the vlookup also updates
and shifts my range down a row....

For example
=VLOOKUP($A$4,$E$10:$E$500,1,False) becomes =VLOOKUP($A$4,$E$11:$E
$501,1,False)

How can I stop the VLOOKUP Range from updating each time I run my
macro?

Disable Range Reference Update in Vlookup
 

Include E9 in the lookup range. It's probably a label or blank and in
either case it will not match your lookup item and so do no harm.

--
Jim
"Matt.Russett" wrote in message
oups.com...
|I have some data that I update every week. I use a macro to update
| this data. The macro moves the old data down one row and copies the
| new data from various places and pastes it to the top row of my table.
| On some other sheets I have vlookups that reference this table. Each
| time that I run my macro to update my table the vlookup also updates
| and shifts my range down a row....
|
| For example
| =VLOOKUP($A$4,$E$10:$E$500,1,False) becomes =VLOOKUP($A$4,$E$11:$E
| $501,1,False)
|
| How can I stop the VLOOKUP Range from updating each time I run my
| macro?
|