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
Bookmarks