Copy Formula - EXACTLY
 

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

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

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

"G" wrote in message
...
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

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

--
Regards,

Dave


"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

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

Regards,
Stefi

€žG€� ezt Ã*rta:

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

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

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.

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