Copying and Pasting VLOOKUP/HLOOKUP Formulas

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?
 
M

Michael

Use the $ sign for fix cell referencing for Example:
If you have B1 change it to $B$1
 
M

Max

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
 
Top