need help with formular built in 2010 but sheet saved in 97-2003

Is there any way to ensure the following formula will work in a 97-2003 saved version of Excel even though created in 2010?
=IFERROR(SUM(IF(ISNA(VLOOKUP(E29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(E29,$B$419:$C$422,2,FALSE))+IF(ISNA(VLOOKUP(J29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(J29,$B$419:$C$422,2,FALSE))+IF(ISNA(VLOOKUP(N29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(N29,$B$419:$C$422,2,FALSE))),"Error")

We created in 2010 and saved to earlier version. However, those people using the spreadsheet in earlier Excel get the #NAME error. Thank you!

Remove IFERROR() from the formula, you're already validating each lookup with ISNA() so it's redundant anyway.

=IF(ISNA(VLOOKUP(E29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(E29,$B$419:$C$422,2,FALSE))+IF(ISNA(VLOOKUP(J29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(J29,$B$419:$C$422,2,FALSE))+IF(ISNA(VLOOKUP(N29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(N29,$B$419:$C$422,2,FALSE))

The only thing which is not recognised in XL2003 is the IFERROR. To make it compatible you would need to do this:

IF(ISERROR(SUM(IF(ISNA(VLOOKUP(E29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(E29,$B$419:$C$422,2,FALSE))+IF(ISNA(VLOOKUP(J29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(J29,$B$419:$C$422,2,FALSE))+IF(ISNA(VLOOKUP(N29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(N29,$B$419:$C$422,2,FALSE)))),"Error",SUM(IF(ISNA(VLOOKUP(E29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(E29,$B$419:$C$422,2,FALSE))+IF(ISNA(VLOOKUP(J29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(J29,$B$419:$C$422,2,FALSE))+IF(ISNA(VLOOKUP(N29,$B$419:$C$422,2,FALSE)),"Invalid",VLOOKUP(N29,$B$419:$C$422,2,FALSE))))

although I have not checked out the logic of the formula - it strikes me that you should be using & instead of + between your internal IFs.

Hope this helps.

Pete

Thank you! I will give it a whirl!