Matching Positive and Negative values with matching non numeric attributes

Hi All,

Can any one assist is providing a unique formula that will match positive and negative with corresponding matching attributes.

e.g.

Find positive and negative values with matching Projects, Cost Centres & POs

Project Cost Centre PO Value Formula needed
N20549 05327 20922767 -100 MATCH
N20549 05327 20922767 100 MATCH
I01392 06391 20899753 100 No MATCH
I01356 06693 20899753 100 No MATCH
I01394 06667 20917173 300 MATCH
I01394 06667 20917173 -300 MATCH
I02466 06686 20916172 400 No MATCH
I01463 06686 20916172 -400 No MATCH

I have tried a few formulas and access queries but I'm unable to crack this.

Your support would be greatly appreciated.

Regards, Mr H

=IF(SUM(INDEX($D$2:$D$18,MAX(IF((A2=$A$2:$A$18)*(B2=$B$2:$B$18)*(C2=$C$2:$C$18)=1,ROW($A$1:$A$16)))),INDEX($D$2:$D$18,MATCH(1,(A2=$A$2:$A$18)*(B2=$B$2:$B$18)*(C2=$C$2:$C$18),)))=0,"","No ")&"MATCH"
as array formula

Hi Glenn,

Thanks for your quick response.

I copied it onto on a larger data set but the formula came back with matches when there wasn't a corresponding -/+.

See attached sample worksheet.

Regards, Mr H

Hi Alkey,

Thanks for you reply.

I have copied the formula into a larger data set and found the formula matches non negatives. What needs to change in the formula to ensure the + / - net off to zero and doesn't find any additional matches.

See attached file.

Thanks again,

Mr H