View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kappy
 
Posts: n/a
Default how do I get a formual to stay constant in vlookup in Excel 2003

When I do a vlookup and drag the formula down all the rows the formula
increments for each row so I wind up only getting partial data to move from
one spreadsheet to another. This is in Excel 2003. Do not seem to have the
same problem in Excel 2000