True/false problem with lookup list/pivot table data

[Onestopfanshop]

I have attached a file that explains this better than I can.

Basically I want to compare a hand entered data sheet to my system data. System data is exported in. Then that data is used to populate a pivot table. I use a lookup list that fills in matching data from my hand typed sheet. From there I want to use true/false to see if the data matches. However, the formula will not copy down. I am sure it has to do with the formula holding a value, but I can’t seem to correct it.

Recap
1. System data populates sheet
2. Pivot table pulls info I need.
3. Lookup list cross references hand entered data sheet and puts value next to pivot table.
4. I need to do a true false to see if data matches but can’t get it to work

Example worksheet:
On the worksheet you can see that the true false statements are incorrect. The system data and the hand entered data match two times not once.