Thomas,

Ok !!! and thanks to you - By placing the $ sign in front of the
"table_array" reference cells and columns it works. Thanks again


"Thomas" wrote:

Hi there,

make the Table array's "absolute" (e.g. $c$1:$F8). Tip: Position your cursor
marker on e.g. C1 and press the F4 key, that' gives you $c$1 automatically)

Thomas

"not 2 excell" wrote:

I am trying to copy a vlookup formula to a whole column of cells with out the
formula changing the "table_array" part of the formula. When the formula is
copyed excell automaticaly changes the "lookup_value" to match the row number
that the cell is copied to. I want it to continue to do that without changing
the "table_array" part of the formula - Thanks in advance