Hi.
I have a problem with which i hope someone can help.
I have a spreadsheet created in Excel 2011, the issue I have is I need to use it on Excel 2003. In the spreadsheet i have the following formula:
=IF(ISBLANK($A3),"",IFERROR(INDEX(Temporary!$A$5:$N$752,MATCH(A3,Temporary!$A$5:$A$752,0),14),IFERROR(INDEX(Permanent!$A$5:$N$752,MATCH(A3,Permanent!$A$5:$A$752,0),14),"MFD")))
Which works perfectly as intended in 2011, but when i come to save it for 2003 I have to modify the formula slightly to:
=IF(ISBLANK($A3),"",IF(ISERROR(INDEX(Temporary!$A$5:$N$752,MATCH(A3,Temporary!$A$5:$A$752,0),14)),IF(ISERROR(INDEX(Permanent!$A$5:$N$752,MATCH(A3,Permanent!$A$5:$A$752,0),14)),"MFD")))
However, it won't work, I get a #NAME? error.
Can anyone point me in the right direction as to where I'm going wrong as Ive run out of ideas.
Thanks in advance.
Bookmarks