Remove #n/a error message

Hi all.

I'm pulling info to one of my sheets from another sheet using the Include and Match functions.

However, when it tries to pull information from a cell that doesn't have any information in it, it puts an "#N/A" into the cell, which makes any calculations made on that column useless.

Is there a way I can get the cell to display a "0" or a text string instead of the "#N/A"?

The function I use to get information into those cells is as follows:

=IF(INDEX('Shipped Items'!D:D,MATCH('Project Sheet'!C7,'Shipped Items'!C:C,0),1)>0,INDEX('Shipped Items'!D:D,MATCH('Project Sheet'!C7,'Shipped Items'!C:C,0),1),"")

Thanks for any help you can provide.

Reymus

So, the stupid question is, which part of what you just gave me actually puts the "0" into the cell if it's not pulling anything from the other sheet?

Never mind. I just opened my eyes enough to figure it out.