Something changed in my spreadsheet and when I enter a formula (=INDEX(xxx, MATCH(yy,zz,0))), it is considered a constant. By that I mean, it thinks it is a regular text string. I tried several experiments to diagnose the problem. I added columns to the table with the same result. I added a new table in a new tab with the same result. Existing cells work fine. When I add a row to the table, the formulas from the other rows in the same column work fine. I must have inadvertantly set a parameter which is causing this but I can't find it. I also made sure the calculation mode is on "Automatic" but this shouldn't be the problem even it it was on.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
repairman615
Well-known Member
- Joined
- Dec 21, 2009
- Messages
- 1,885
Hello,
Maybe try to remove the outer parenthesis like:
=INDEX(xxx, MATCH(yy,zz,0))
Maybe try to remove the outer parenthesis like:
=INDEX(xxx, MATCH(yy,zz,0))
Upvote
0
May be give this a shot:
Not sure for later versions, but in 2003 if you click on HELP there is an option called Detect and repair , try that, maybe some control files went bad. Few months back I could not get to help file and it caused the software to crash, after running the Detect and repair, it is back to normal. Just a suggestion
Not sure for later versions, but in 2003 if you click on HELP there is an option called Detect and repair , try that, maybe some control files went bad. Few months back I could not get to help file and it caused the software to crash, after running the Detect and repair, it is back to normal. Just a suggestion
Upvote
0
Similar threads
- Question
- Question
