| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula not updating
I am having a problem with a match function not updating. My workbook is set
to automatic calculation. This is the formula: =INDEX('101 Competition'!$A$10:$FV100,MATCH($A$6,'101 Competition'!$A10:$A100,),MATCH(Q11,'101 Competition'!$A$10:$FV$10,)) The formula does not update. I hit F9 and still no update. But when you highlight the cell, click the Fx button, and hit enter the cell updates correctly. Why won't Excel automatically pull a value, or at least pull it when F9 is pressed? -- Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| Help with a formula | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Threaded Mode
