Comparing Positive amount with Negative Amount

[coolkiran]

Hello All

I am working on Excel file which have 2 sheets, first and second sheets with 4 columns. I want to concatenate 4 columns in a order "Amount", "Name", "Country" and "Bill No".

Once done, I want to compare these 2 columns, if i found opposite sign value with same values, then i have to update as Matching else Not Matching.

Eg : One sheet containing value as "100CIndia1" and second sheet contains "-100CIndia1" then it will be matching.
If in both sheets value is 100CIndia1 then it will be Not Matching.

Any suggestions please. I have attached sample file.

 

[Marc L]

Hi !

Formula in F2 cell :

=IF(ISNA(MATCH(-D2&A2&B2&C2,Sheet2!$E$2:$E$4,0)),"Not Matching","Matching")

Copy down …
​

 

[coolkiran]

Thanks it worked.