Copying and Pasting VLOOKUP/HLOOKUP Formulas

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I created a pretty long formula that use VLOOKUP/HLOOKUP's referencing ranges
in another worksheet. When I copy/paste the formula to other cells, it
changes the parameters of the range. How can I copy/paste without it
changing the ranges?
 
If you copy it directly from within the source formula bar, and then paste it
directly into the destination cell's formula bar, does that achieve the
desired results for you?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
 
Back
Top