Named Range changes when data is imported
 

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

Named Range changes when data is imported
 

Try deleting Column A before you import.

"Matt7102" wrote:

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