View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default vlookup formula not copying

Post your formula.

--

wrote in message
...
I manually put the vlookup formula into one row of my worksheet. It's
working fine. When I try to drag the formula down to the other rows,
it copies everything except the range lookup. It just puts #ref where
the range should be. That has never happened to me before. Is there
something I'm doing wrong? I'm using Excel 2007. Any help would be
appreciated. Thanks, Daryl