|If you are looking for an exact match, you need to use FALSE (or 0) as the range_lookup argument. If it is TRUE (1) or omitted (as it appears to be in what you posted) an approximate match will be returned.|
Now, since the range_lookup argument has been omitted, and an approximate match is being returned, it seems to me that what appears to be a match that you can see with your own eyes really isn't.
Here's a test:
Find 2 cells that appear to be a match, e.g. A2 and 'Actual Count'!A5.
Enter this in a cell:
If that does not return TRUE, then it's not a match.
If it's not a match try things like:
Maybe there's an extra space, or a hidden character or something.
Let me know what you find.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.