View Single Post
  #1   Report Post  
Sigmaz
 
Posts: n/a
Default 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))