iserror #n/a can't solve

[krcroteau]

can anyone add an iserror to the formula below i am failing?


=VLOOKUP($C98,Affiliates!$A:$V,3,FALSE)*SUM($S98,$T98,$M98)+VLOOKUP($C98,'[forecast 04 2007 fr group.xls]MG2_ALL'!$A:$U,21,FALSE)

[NBVC]

Try:

Please Login or Register  to view this content.

You can replace the double quotes, "", with a 0 or any other number/string that you want returned when error occurs. Currently it will return a null string.