Copy Formula - EXACTLY

G

G

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
 
D

DaveB

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

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.
 
B

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
 
Top