Disable Range Reference Update in Vlookup

  • Thread starter Thread starter Matt.Russett
  • Start date Start date
M

Matt.Russett

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup issue 2
Vlookup in VBA 2
Vlookup in a Macro 1
Update link on vlookup from closed excel file 2
Reference Cell in VLOOKUP 5
Defining a dynamic table_array for vlookup 9
Columns as variable in Vlookup 5
Vlookup in vba - how to use absolute rows not relative 1

Back
Top