Excel

Paste Table A (ID | Name | Amount)

Paste Table B (Name | Amount)

Section C: Final Output

1. COMMON MATCHES

ID	Upper Name	Transaction Amount(INR)

2. DUPLICATE MATCHES

ID	Upper Name	Transaction Amount(INR)

3. UNMATCHED ENTRIES

ID	Upper Name	Transaction Amount(INR)