TROUBLE COPYING AND PASTING FORMULAS

I'm trying to copy the following formual into a column of cells:
=VLOOKUP(G10,Data!B1:C11,2,FALSE)

But every time I copy/paste, Excel decides to change my Data!B1:C11 table
array screwing up my formula. There has got to be a better way. Also, this
will not allow me to cut and paste multiple versions of my excel file. The
"look up" value does change appropriately.

Please help. I have tried everything.

One way is to lock the table_array (make it as: Data!$B$1:$C$11)
viz. use instead the expression:
=VLOOKUP(G10,Data!$B$1:$C$11,2,FALSE)

Alternatively, we could create a defined range for the table_array
via clicking Insert > Name > Define, with the settings as:
MyTable: =Data!$B$1:$C$11
(Names in workbook: Refers to)

and then use it as: =VLOOKUP(G10,MyTable,2,FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"belga" wrote:
> I'm trying to copy the following formual into a column of cells:
> =VLOOKUP(G10,Data!B1:C11,2,FALSE)
>
> But every time I copy/paste, Excel decides to change my Data!B1:C11 table
> array screwing up my formula. There has got to be a better way. Also, this
> will not allow me to cut and paste multiple versions of my excel file. The
> "look up" value does change appropriately.
>
> Please help. I have tried everything.
>
>

one way of copying a formula EXACT IS

highlight formula in the formula bar
control+C
ESC----this is important
select destination
control+V
try this

"Max" <[email protected]> wrote in message
news:[email protected]...
> One way is to lock the table_array (make it as: Data!$B$1:$C$11)
> viz. use instead the expression:
> =VLOOKUP(G10,Data!$B$1:$C$11,2,FALSE)
>
> Alternatively, we could create a defined range for the table_array
> via clicking Insert > Name > Define, with the settings as:
> MyTable: =Data!$B$1:$C$11
> (Names in workbook: Refers to)
>
> and then use it as: =VLOOKUP(G10,MyTable,2,FALSE)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "belga" wrote:
>> I'm trying to copy the following formual into a column of cells:
>> =VLOOKUP(G10,Data!B1:C11,2,FALSE)
>>
>> But every time I copy/paste, Excel decides to change my Data!B1:C11 table
>> array screwing up my formula. There has got to be a better way. Also,
>> this
>> will not allow me to cut and paste multiple versions of my excel file.
>> The
>> "look up" value does change appropriately.
>>
>> Please help. I have tried everything.
>>
>>