Copy Formula - EXACTLY

[Guest]

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

 

[Anne Troy]

Try this, G: =VLOOKUP("1A",Players!$C$4:$F$57,4,FALSE)

************
Anne Troy
www.OfficeArticles.com

 

[Guest]

Copy the formula from the formula bar, that way you are copying text instead
of a cell reference.

 

[Guest]

=VLOOKUP("1A",Players!$C$4:$F$57,4,FALSE)

Regards,
Stefi

„G†ezt írta:

 

[Guest]

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

 

[John Michl]

Note that is using the absolute reference works for you, you can cycle
through the absolute options by pressing the F4 key while editing the
formula.

 

[Blue Hornet]

G,

You could also select the search range, C4:F57, and name the range
(Insert / Name / Define). Call it something like "MyTable".

Then your formula would be:
=vlookup( "1A", MyTable, 4, False)
and you could copy it anywhere to maintain that reference.

Chris