Vlookup, Match functions do not work

[bkish]

I have a sheet which takes data from two different sheets to compare to each other. I use the trim function on one to get the data to match the other. I am left with a 6 digit number that should be the same for both sets of data. Match, Vlookup, and =A3=B3 comes back FALSE. When I evaluate formula I can see A3=123456, but B3="123456". If I copy and paste the cells as values then it works but as soon as I put the formula in it does not.

Any ideas on how to get them to be in the same format?

 

[wildcloud]

you may either convert
"123456" to number by using ="123456"+0
or
123456 to text by using text(123456,"#")

 

[tbeards]

use Value(trim(A1)) in your formula to keep the numbers as values where A1 is the cell you are referencing.

~t

 

[mikerickson]

On a column of numerals (text strings like "12345") use TextToColumns with a Tab delimiter. If you choose General in the last dialog page, the column will become numbers.

 

[bkish]

I added the Value() around my trim function and that did the trick. Thanks for those who replied. As usual, outstanding job.