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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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