Disabling Cell References

[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)

 

[Dave Peterson]

=vlookup(indirect("a1"),d1:e2,2,0)

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

 

[camerons]

Thank You!

=vlookup(indirect("a1"),d1:e2,2,0)

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