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