Saving data ranges for Vlookups

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

Guest

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.
 
You must log in or register to reply here.

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

The cell currently being evaluated contains a constant 1
Copying and Pasting VLOOKUP/HLOOKUP Formulas 2
Vlookup cell reference 6
Dynamic named range reference from external workbook 2
Named Range changes when data is imported 1
Vlookup Reference Certain Worksheets 4
Forumlas Aren't Auto Recalculating 1
Adding the IF function to a VLOOKUP function. 2

Back
Top