I have 2 excell sheets
once contains the payments made by my bank basing on the cheque no and amount
another contains (general ledger / gl)documnet no and amount. Both the
sheets are having more than 20 columns and 20000 rows. Here i want a formula
which should match contents of the bank statement (from top to bottom) with
general ledger on doc no and amount, if it matches it should put remark as
"Matched" in both the sheets, if it not matches as "Unmatched". If one entry
in bank statement is already matched with general ledger and if it repeats
again, it should show "already matched". Like wise it should run through out
the sheet.

Thanks in advance for you guys who are ready to help me