False negative result using column "=" formula

[bigmyk2k]

I am trying to update a large dataset, and want to look at what values are updating to new values vs. which are the same.

Column A: numerical values, copy/paste from a separate table (in a different program)
Column B: numerical values, VLOOKUP result from a different sheet in the same workbook.
Column C: "=[Column A]=[Column B]"

The problem is that all values in Column C are "FALSE" when a simple skim of the first several rows reveals several that should be "TRUE".

I thought this might be related to formatting, but both columns are formatted as numbers.
I then considered whether it may be how Excel is interpreting the VLOOKUP function, but I copied and pasted as values, and still had the same problem.
Also, all values are to the same number of sig. figs., so there isn't a rounding problem.

Thoughts?

 

[bigmyk2k]

[facepalm]

Ugh, never mind. I just discovered that most of the values in the reference table for Column B have a leading apostrophe. Just not the several I checked before losing it.