Hello,

I have this formula that i need to return zero if there is no value to return. This is for a summary page on a workbook with 30 sheets. The formula is as follows:

=INDEX('Corp Nov - 13'!$A$1:$I$1000,SMALL(IF('Corp Nov - 13'!$A$1:$A$1000='Daily Summary'!$I$1,ROW('Corp Nov - 13'!$A$1:$A$1000)),ROW(1:1)),1)


Thanks in advance for any help. I am new to this so if there is additioall information just let me know.