Copying and Pasting VLOOKUP/HLOOKUP Formulas
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? |
Copying and Pasting VLOOKUP/HLOOKUP Formulas
Use the $ sign for fix cell referencing for Example:
If you have B1 change it to $B$1 -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "DS" wrote: 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? |
Copying and Pasting VLOOKUP/HLOOKUP Formulas
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 --- "DS" wrote: 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? |
All times are GMT +1. The time now is 07:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com