Hi,

I have a worksheet that I send to HQ every week:

Col A = Reference Number
Col B = Amount
Col C = Name
etc.

At the end of the month HQ sends me a consolidated report for the month
(same column headings).

Please write me the formula on how to match my "Reference Number" to the
consolidated report and see if the "Amount" of the corresponding "Reference
Number" is still the same.

My weekly report usually has 200-300 rows. The consolidated report is up to
5,000 rows.

Thank you.