On Oct 3, 4:13 pm, Danny wrote:
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.

Something like this ought to do the trick:
=IF(VLOOKUP(A2,Sheet2!A:C,2)=B2,"OK","DIF")
where this would be a new column in your original report and Sheet 2
is the consolidated report. VLOOKUP does the matching and finds the
corresponding amount while IF does the comparison to see if the value
is the same.

That should at least point you in the right direction.