INDEX function issues

[Dean]

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

 

[Bob Phillips]

Have you got the workbook set to manual calculation
(Tools>Options>Calculation)?

--
HTH

Bob

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

 

[PCLIVE]

Calculations are probably set to manual.

Tools-Options-Calculation-Automatic

Regards,
Paul

 

[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

 

[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