Conditiona Index/Match Statement Help

[jmazorra]

Hello:

I have the following formula

=INDEX(CCMSTime!C:C,MATCH(A2,CCMSTime!A:A,0))

Works great, except when there is nothing to return I get the following

#N/A

, which causes problems when I am trying to do SUM

How can I rewrite my formula so that if there is nothing to return Excel places a 0 instead of #N/A?

Thank you.

 

[ExcelElliott]

Try this:

=IFNA(INDEX(CCMSTime!C:C,MATCH(A2,CCMSTime!A:A,0)), 0)

 

[jmazorra]

Thank you, it worked perfect