Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
=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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a reference formula onto multiple worksheets | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions |