|
|
paste formula to each cell in a column without changing values |
|
Author |
Message |
heckmanm
|
Posted: Wed May 24 05:30:02 CDT 2006 |
Top |
worksheet functions >> paste formula to each cell in a column without changing values
Hi,
I have the following formula that I need in every cell of column G on my
worksheet
VLOOKUP(C:C,'Daily Code 10s'!1:65536,3,FALSE)
Obviously when I copy and paste this from one cell to another it changes the
formula to
VLOOKUP(C:C,'Daily Code 10s'!#REF!,3,FALSE)
Now copying and using paste special on each cell individually is going to
take an eternity so is there a way to copy this to every cell in column G
without it changing the formula?
Thanks in advance for any help.
J
Excel338
|
|
|
|
|
FSt1
|
Posted: Wed May 24 05:30:02 CDT 2006 |
Top |
worksheet functions >> paste formula to each cell in a column without changing values
hi,
try using absolute references in the formula.
VLOOKUP(C:C,'Daily Code 10s'!$1:$65536,3,FALSE)
see xl help on absolute references vs relative references.
regards
FSt1
> Hi,
>
> I have the following formula that I need in every cell of column G on my
> worksheet
>
> VLOOKUP(C:C,'Daily Code 10s'!1:65536,3,FALSE)
>
> Obviously when I copy and paste this from one cell to another it changes the
> formula to
>
> VLOOKUP(C:C,'Daily Code 10s'!#REF!,3,FALSE)
>
> Now copying and using paste special on each cell individually is going to
> take an eternity so is there a way to copy this to every cell in column G
> without it changing the formula?
>
> Thanks in advance for any help.
>
> J
>
>
>
|
|
|
|
|
|
|