replace #N/a with 0

[Armageddon85]

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.

[NBVC]

Try:

Please Login or Register  to view this content.

[Simon Lloyd]

Possibly this will do it!
=IF(ISNA(INDEX(pdrop!$B$4:$K$62,MATCH(E3,pdrop!$A$4:$A$62,0),MATCH(D3,pdrop!$B$3:$K$3,0))*(C3/100)),0,INDEX(pdrop!$B$4:$K$62,MATCH(E3,pdrop!$A$4:$A$62,0),MATCH(D3,pdrop!$B$3:$K$3,0))*(C3/100))

[Armageddon85]

perfect! thanks for your help.