Copying and Pasting VLOOKUP/HLOOKUP Formulas

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

 

[Michael]

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

 

[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