G
Guest
I am having a problem with my index formula not refreshing.
My workbook is set to automatic calculation. Also, when I hit F9, the
formula is not updated. But when I hit the Fx button on the toolbar, the
formula does update. Also, when it is pasted somewhere, the formula updates.
But if you then change a value on the lookup sheet, it again does not update
even if F9 is pressed. Also, if the sheet is reopened, the formula refreshes.
But somehow if does not dynamically update. All of the other formulas on the
sheet update automatically.
This is the formula:
=INDEX('107 Competition'!$5:$100,MATCH($A$6,'107
Competition'!$A$5:$A$100,),MATCH(Q35,'107 Competition'!$5:$5,))
I'm at wits' end so any help would be much appreciated.
My workbook is set to automatic calculation. Also, when I hit F9, the
formula is not updated. But when I hit the Fx button on the toolbar, the
formula does update. Also, when it is pasted somewhere, the formula updates.
But if you then change a value on the lookup sheet, it again does not update
even if F9 is pressed. Also, if the sheet is reopened, the formula refreshes.
But somehow if does not dynamically update. All of the other formulas on the
sheet update automatically.
This is the formula:
=INDEX('107 Competition'!$5:$100,MATCH($A$6,'107
Competition'!$A$5:$A$100,),MATCH(Q35,'107 Competition'!$5:$5,))
I'm at wits' end so any help would be much appreciated.