use pivot table data in vlookup formula
 

When I copy the results of a pivot table to another worksheet, the vlookup
formula in the other worksheet does not recognize the same number from the
data that came from the pivot table. I have made sure that the columns are
formatted the same. If, however, i actually type in the number, the vlookup
then recognizes the number to be what it's looking for.