Disabling Cell References

  • Thread starter Thread starter camerons
  • Start date Start date
C

camerons

Lets say cell B1 is =SUM($A$1:$A$2) if I drag cell A1 somewhere else the
formula doesn't change. However if the formula in B1 is
=VLOOKUP($A$1,D1:E2,2,0), Excel will replace A1 in the formula with whatever
I dragged that cell to. Is it possible to stop this?
Chris Cameron
(e-mail address removed)
 
=vlookup(indirect("a1"),d1:e2,2,0)

should always point at A1--no matter what happens!
 
Back
Top