Comparing two data sets that don't line up on a line to line basis

Hi,

I have two datasets, Invoices and Purchase Orders and I am trying to compare the subtotal amounts for them to make sure they are the same. Invoices has the names of all the employees who worked on it and all those employees are applied the same Purchase Order. So I use the subtotal function to sumup the PO.

The other dataset has the lump sum amount of the POs.

The problem is that the subtotals in the invoices dataset do not line up with the POs because the invoices has more rows (because it has the list of employees that worked on that).

Is there any macro or conditional formating rule that can be applied to overcome this problem?

Thanks for the quick response.

The formula you gave gives me an error.

What I am trying to do is to compare the Subtotals in Column B and H and make sure that are same. However, the problem is that they do not line up properly on a line-to-line basis. For example, the PO Subtotal in Column B is on Row 5 where as the PO Subtotal in Column H is on the forth row.

Any suggestions?

I replaced all the commas with semicolons but I am still getting the same error:
'The Formula you typed contains an error'

Hi Soren,

Thank you so much for your help. There are however 5 subtotals that are being inaccurately displayed as 'Not Ok' even though the dollar amount match.

They are Column B, Rows 80, 137, 157, 189, 192, 195.

Any clues as to why these are being inaccurately labeled as 'Not Ok'?

Thank you sooo much!!!