Compare tracker with actuals formula?

[Sprinter06]

Hi,

I'm trying to see if there is a way a formula can tell me if the data I have in my tracker matches the data of another table of data (actuals) when I do a pull every month. I cant find a way to paste my example so I apologize for the example below but basically i would want the check column to have this formula to see if the table to the right of it matches or not. Any help would save me so much time instead of going line by line every month. thanks!

[TABLE="width: 708"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 5"]My Tracker[/TD]
[TD][/TD]
[TD="colspan: 4"]Actuals Pull[/TD]
[/TR]
[TR]
[TD]Account[/TD]
[TD]Vendor[/TD]
[TD]Invoice #[/TD]
[TD]Amount[/TD]
[TD]CHECK[/TD]
[TD][/TD]
[TD]Account[/TD]
[TD]Vendor[/TD]
[TD]Invoice #[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Marketing[/TD]
[TD]Logitech[/TD]
[TD="align: right"]1[/TD]
[TD] 5,000.00[/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD]Marketing[/TD]
[TD]Logitech[/TD]
[TD="align: right"]1[/TD]
[TD] 5,000.00[/TD]
[/TR]
[TR]
[TD]Retail[/TD]
[TD]Target[/TD]
[TD="align: right"]1[/TD]
[TD] 46,800.00[/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD]Retail[/TD]
[TD]Target[/TD]
[TD="align: right"]12[/TD]
[TD] 50,000.00[/TD]
[/TR]
[TR]
[TD]Corporate[/TD]
[TD]Jake Smith[/TD]
[TD="align: right"]22[/TD]
[TD] 668.00[/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD]Corporate[/TD]
[TD]Jake Smith[/TD]
[TD="align: right"]2[/TD]
[TD] 668.00[/TD]
[/TR]
[TR]
[TD]International[/TD]
[TD]BlueSky[/TD]
[TD="align: right"]4652[/TD]
[TD] 9,800.00[/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD]International[/TD]
[TD]BlueSky[/TD]
[TD="align: right"]4652[/TD]
[TD] 9,800.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about using conditional Formatting?
Select the data on 1 sheet & use this formula
=A1=Sheet1!A1

Assumes data starts in A1, change the sheet name to suit