View Single Post
  #5   Report Post  
Sandy
 
Posts: n/a
Default

Use absolute reference $C$4:$F$57

"G" wrote:

Somewhat of a novice with Excel ... how do I copy a formula and paste it
without having the formula change the range?

Here's what I'm copying:

=VLOOKUP("1A",Players!C4:F57,4,FALSE)

I'm pasting it to another cell and here's what's being copied:

=VLOOKUP("1A",Players!C8:F61,4,FALSE)

I want ALL copied cells to have the range C4:F57. Thanks.

G