I have a column with a lookup formula (=VLOOKUP(B13,Contactlist!A9:D78,3,FALSE)). I need to copy this formula to stay A2:D70. Every time I copy this formula to the next cell in the column it increases "A2" to "A3" and "D70" to "D71" and so on. Is there a way to copy this formula to make A2:D70 stays the same? Or is there a way to find and replace any values for example A9:D78 to A2:D70
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel TechHelp.
