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?
|