Hi!

=IF(ISNA(MATCH(1,(EXPORTSUMMARY!A2:A60=2)*(EXPORTS UMMARY!
B2:B60=1),0)),0,INDEX(EXPORTSUMMARY!C2:C60,MATCH(1 ,
(EXPORTSUMMARY!A2:A60=2)*(EXPORTSUMMARY!B2:B60=1), 0)))

Biff

-----Original Message-----
Can anyone please help me wrap this formula with an IF
ISNA function so that
the result returns a 0 instead of #N/A when values aren't
available to
satisfy the match.

=INDEX(EXPORTSUMMARY!C2:C60,MATCH(1,(EXPORTSUMMAR Y!
A2:A60=2)*(EXPORTSUMMARY!B2:B60=1),0))
.