IF ISNA HELP, please..I cant add #N/A but 0 is another story
 

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,(EXPORTSUMMARY !A2:A60=2)*(EXPORTSUMMARY!B2:B60=1),0))

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))
.

Biff, You rule man!!.. thank you so much for all your help!!!
That works perfectly.. I have alot to learn...
Thanks again!


"Biff" wrote:

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))
.