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

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

Calculations are probably set to manual.

Tools-Options-Calculation-Automatic

Regards,
Paul


--

"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

Nope. I am a rookie at macros, but this kind of thing I know. I often have
it set to automatic except data tables, but never manual.

I tried exiting EXCEL and it seemed to help once, but then not on the second
change I made in order to change the values as a test. Perhaps, I should
reboot the computer? Or do you think I must have a corrupt EXCEL? It seems
that the IF statement is getting in the way. Without the IF statement, the
function updates as it should.

Actually, right now, it seems fine, so this seems to be an intermittent
problem! I seem to recall this kind of problem before in my dark past
with some other similar function inside an IF statement. I seem to recall,
it also spontaneously disappeared. Any thoughts?

Thanks!
Dean

"Bob Phillips" wrote in message
...
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

Actually, I am having the problem on another version of the worksheet, but
with no complex function such as "index" inside. Rather, the "then"
conditions are merely references to other cells, those cells being on
another worksheet, FWIW.

Once again, I am on automatic recalc. I tried closing out the file, didn't
help. Then, closing out EXCEL, didn't help. I bet rebooting will help, but
that seems too drastic.

Since this template is being developed for simple users, this problem could
get ugly! Does anyone have any thoughts on this?

Dean

"Dean" wrote in message
...
Nope. I am a rookie at macros, but this kind of thing I know. I often
have it set to automatic except data tables, but never manual.

I tried exiting EXCEL and it seemed to help once, but then not on the
second change I made in order to change the values as a test. Perhaps, I
should reboot the computer? Or do you think I must have a corrupt EXCEL?
It seems that the IF statement is getting in the way. Without the IF
statement, the function updates as it should.

Actually, right now, it seems fine, so this seems to be an intermittent
problem! I seem to recall this kind of problem before in my dark past
with some other similar function inside an IF statement. I seem to
recall, it also spontaneously disappeared. Any thoughts?

Thanks!
Dean

"Bob Phillips" wrote in message
...
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