Is there an equivalent to ISNA() for #NAME? errors?

[lit8rtot]

I am using Excel 2007. I have daily report spreadsheets that contain named cells referring to summary data. I have another spreadsheet that "rolls up" all available daily reports by using formulas referring to the named cells in the daily workbooks.

These formulas work great - as long as the named cell actually exists. I have used the ISNA() function in formulas to be able to handle (for example) VLOOKUP functions that cannot find an exact match, and return the #N/A error. For example:

IF(ISNA(VLOOKUP ("foo", Data!$A$1:$D$20 00,3,FALSE)),"N A",VLOOKUP("foo ", Data!$A$1:$D$20 00,3,FALSE))

I have been unable to find an equivalent function or method that can be used in an Excel formula for handling $NAME? errors. Can anyone help me?

[ubentook]

You can use IsError or IsErr to trap the #Name error.
Also, xl2007 added the IfError function.
Of course that won't work with earlier versions of Excel

[lit8rtot]

Awesome! Perfect - exactly what I was looking for! Thank you.