copy a lookup in a range without advancing the cell reference

  • Thread starter Thread starter garcam
  • Start date Start date
G

garcam

It's driving me crazy! It seems like I could use the auto fill
function and it would keep the correct cell references for the
lookup. What am I doing wrong?
 
Without seeing the formula I would say you should make the Table references
Absolute.

=VLOOKUP(D2,$A$1:$C$25,2,FALSE)

D2 will change as you autofill but the Table will stay the same.

OR give your Table an defined name.

=VLOOKUP(D2,myTable,2,FALSE)


Gord Dibben MS Excel MVP
 
Back
Top