TROUBLE COPYING AND PASTING FORMULAS

[Guest]

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.

 

[Guest]

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)

 

[R..VENKATARAMAN]

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