Have you got the workbook set to manual calculation
(ToolsOptionsCalculation)?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dean" wrote in message
...
I am using an index function within an if statement and it doesn't seem to
be automatically recalc'ing the index function's value. If I go into edit
mode, take out the last paren, then put it back, it updates (or if I copy
the formula below to another cell, the other cell updates), but it doesn't
do it automatically. Does anyone know why? If index is a problem, would a
lookup function fare better?

Here is the statement (cell K145 is TRUE):

=IF($K145=TRUE,INDEX('V3'!$A$153:$M$153,1,9),"")

Thanks!
Dean