| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Disabling Cell References
|
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixed cell references | Excel Discussion (Misc queries) | |||
| Absolute References in cell formula | Excel Worksheet Functions | |||
| How to use complex no. functions that have cell references? | Excel Worksheet Functions | |||
| Cell references change when entering new data | New Users to Excel | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Linear Mode
