ExcelBanter - Disabling Cell References

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Disabling Cell References (https://www.excelbanter.com/new-users-excel/42146-disabling-cell-references.html)

camerons

Disabling Cell References

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

=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

camerons

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

All times are GMT +1. The time now is 10:37 AM.