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