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

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...