| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
| Need formula to lookup a named range | Excel Discussion (Misc queries) | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Linear Mode
