Named Range changes when data is imported

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Vlookup; referencing a sheet that I clear contents (old data),
import new data on. The named range is defined as DATA06;
'0422j!'$A$1:$D$144. After import, I delete column A. The range definition
is changed to '0422j!'$A$1:$C$144. I tried directly inserting the range into
the Vlookup formula, but it changes as well. Any ideas how I can stabilize
the defined range?

Thanks, Matt7102
 

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

Help with SMALL formula. 12
Dynamic named range reference from external workbook 2
Importing named range from another workbook 5
Errors when using named ranges 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Chart data - Range Names 1
Custom Calculation in a Pivot Table 1
Dynamically Naming a Table of Data 2

Back
Top