Thread: vlookup
View Single Post
  #2   Report Post  
BrianB
 
Posts: n/a
Default


In the absence of another reply ........
Perhaps you have a later version of Excel that does fancy things - in
which case "It is a feature, not a bug" and you will need to have a
look at Help.
I am still using XL97 here and do not get these problems. :)

Copy the cell.
Select cells below the formula.
Edit/Paste Special/Formulas.


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=272941