Matching Debits and Credits in one column with Vendor Criteria from another column

Hello Excel Community!

I have been working on trying to develop a function that will be used to search a specific Vendor name, than return ANY MATCHING Debit (negative value) and Credits (Positive Value) to result in a canceling of transaction value. I was fortunate to find this function, from a very helpful source on this forum..

=IF(B2="","",IF(B2<0,-B2&"_"&COUNTIF(B$2:B2:B11,B2),B2&"_"&COUNTIF(B$2:B2:B11,B2)))

Then follow it up by:

=IF(COUNTIF(C:C,C2)=2,"x","")

This equation assumes Vendor in column A, Debit and credits in column B


the function seems to work great for matching most D's to C's, but it is also matching values that are opposite for different vendors (EG; 200 for one vendor and -200 for a totally opposite vendor).

I was wondering if anyone could put something into place to search vendor criteria, THAN corresponding debits and credits..

You all are the best!

Excel Debit _Credit.PNG