I am using an index match formula to return the volume of seven different activities of a list of companies. Some of the activities may be blank for a particular company. When this occurs, I get a #value! error. I have tried using the IF(ISNA function and this hasn't solved the problem.

All I am looking for is a zero for the activity if a company has no volume for that particular activity for the month I am reviewing.

=IF(ISNA(INDEX('2004 deposits'!$A$2:$I$1500,MATCH($A10,'2004 deposits'!$A$2:$A$1500,0),4)/2000),0,INDEX('2004 deposits'!$A$2:$I$1500,MATCH($A10,'2004 deposits'!$A$2:$A$1500,0),4)/2000)

Any help would be greatly appreciated.

Thank you

Todd