Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving data ranges for Vlookups
I am using Vlookups that reference values on another tab. If the referenced
values are deleted the data ranges are lost. If new data is pasted into the referenced tab the vlookups still do not work. I tried naming the array but it too lost the referenced cells once deleted. Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving data ranges for Vlookups
rather than delete, try clear the cells
"msiegmund" wrote: I am using Vlookups that reference values on another tab. If the referenced values are deleted the data ranges are lost. If new data is pasted into the referenced tab the vlookups still do not work. I tried naming the array but it too lost the referenced cells once deleted. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Ranges | Excel Worksheet Functions | |||
Vlookups in a Pivot table brining back OFFSET Data | Excel Worksheet Functions | |||
Data ranges | Charts and Charting in Excel | |||
IRR data in different ranges | Excel Worksheet Functions | |||
Saving Excel ranges as database tables | Excel Discussion (Misc queries) |