| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you link HLOOKUP AND VLOOKUP formulas and return their interce | Excel Worksheet Functions | |||
| TROUBLE COPYING AND PASTING FORMULAS | Excel Worksheet Functions | |||
| Copying/Pasting Formulas | Excel Discussion (Misc queries) | |||
| Copying and pasting multiple formulas, it it possible? | Excel Discussion (Misc queries) | |||
| Copying & pasting formulas | Excel Worksheet Functions | |||
Threaded Mode
