Hello!
After almost a month where i have not touched my large excel sheet, suddenly all the index formulas that worked several times previously don't work. This formula was made with the help of NBVC on the following thread:
http://www.excelforum.com/excel-gene...opy-paste.html
The formulas look something like this:
Portuguese translation for functions:
INDEX = ÍNDICE
MATCH = CORRESP
TEXT = TEXTO
YEAR = ANO
Basically, if I grab the sheet that used to work, go into a cell that contains this formula and hit enter, the result suddenly changes to #N/D. Does anybody have any ideas how this could have happened?
Thanks in advance.
Bookmarks