It looks like Zack made a cut/paste error here . Notice there are two equal signs (=). Try this:
PHP Code:
=IF(ISNA(INDEX(Data1,MATCH($A3,Code,0),MATCH(B$2,Contract, 0))),"ERROR",INDEX(Data1,MATCH($A3,Code,0),MATCH(B$2,Contract, 0)))
--------------------------------------------------------------------------
For a general formula you can use this for NA Errors
PHP Code:
=If(ISNA(Formula),"Error",Formula)
This is really not efficient though. Excel has to evaluate the "Formula" twice and if we have thousands of these complex formulas it could impact the speed of your spreadsheet.
--------------------------------------------------------------------------
If it is possible use two cells for each formula. Basically setup two tables or columns one for the formula and one to check if it is NA or some other error.
For example:
Let's say your original formula is in Z1
PHP Code:
= INDEX(Data1,MATCH($A3,Code,0),MATCH(B$2,Contract, 0))
Z1 can be hidden so you don't even see it.
In A1 you can put this.
PHP Code:
= If(ISNA(Z1),"Error",Z1)
--------------------------------------------------------------------------
morefunc is attached. Just unzip it and follow the Readme.txt instructions to install it. But just make sure you understand that any functions you use from that add-in will only work on PCs that have the add-in.
So if you use morefunc functions and send the spreadsheet to someone that doesn't have the add-in, it won't work.