Thomas,

Sounds good to me however I am not very excell savy. when I hit F4 it opend
a new workbook?? (I know it's me not you) the formula that I am using is
=VLOOKUP(A4,'PSI Data '!=VLOOKUP(A4,'PSI Data '!A2:Z2000,12,FALSE),12,FALSE).
I need the A2:Z2000 part to stay the same in each copied cell

"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