Thank You!



"Dave Peterson" wrote in message
...
=vlookup(indirect("a1"),d1:e2,2,0)

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

camerons wrote:

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


--

Dave Peterson