View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DS DS is offline
external usenet poster
 
Posts: 117
Default 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?