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!

My Tracker		Actuals Pull
Account	Vendor	Invoice #	Amount	CHECK		Account	Vendor	Invoice #	Amount
Marketing	Logitech	1	5,000.00	TRUE		Marketing	Logitech	1	5,000.00
Retail	Target	1	46,800.00	FALSE		Retail	Target	12	50,000.00
Corporate	Jake Smith	22	668.00	FALSE		Corporate	Jake Smith	2	668.00
International	BlueSky	4652	9,800.00	TRUE		International	BlueSky	4652	9,800.00

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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