copying cells to increment cell reference

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

I have a formula in a cell I1 that reads:

=vlookup(I2,K1:L280,2,0)

I want to copy this formula with the I2 incrementing every row, but the
table reference staying at K1:L280. If I drag it increments every
number. If I manually set the formula in three cells, then highlight
all three and drag the cell by the handle, it will increment the I2,
and it will increment the table to K4:284 and THEN copy correctly not
incrementing the table the rest of the way. But I need it to not
increment the table reference at all.

Thanks

p.s. out of curiosity, does using data valadation make the file open
slower? The file size of my file is only 987kb, but I can bring up much
larger files faster than this one opens
 
Kenneth,

You need to make your reference to your table absolute, so it won't change
when copied

=vlookup(I2,$K$1:$L$280,2,0)

Put the cursor on (or select) it, and press F4.

Peo's suggestion of using a name is better.
 
Replace your formula with

=vlookup(I2,$k$1:$l$280,2,0)

The $ signs lock the cells that you want referenced.
 
Back
Top