I have the following formula: =INDEX(pdrop!$B$4:$K$62,MATCH(E3,pdrop!$A$4:$A$62,0),MATCH(D3,pdrop!$B$3:$K$3,0)) * (C3/100)

which spits out #N/A if one of the values is missing. How do I make it so it shows a zero or nothing at all; so when I do a sum of the #n/a column I can only sum up the values that are there.