Pasting to Excel For VLOOKUP

[JeffGeorge]

I am copying and pasting the results of an Access query to Excel for the purposes of using that data as the source for a VLOOKUP. However, it seems that no matter what I do the cells that were pasted from Access do not correspond to the same values that are in the lookup table in Excel. For example, I want to find the value ABC from column A of the pasted Access data to find the corresponding ABC in the Excel array. It doesn't consider it a match even though both cells are formatted the same way. I've even gone so far to test it by putting a logical comparison of the specific cells in another cell and it claims they are not the same even though the values are exactly the same. The only thing that seems to work is if I manually type over the value pasted from Access with the same value that is already in the cell. Then the VLOOKUP works. However, I am not about to go typing all these values manually. That's why I used an Access query. How do I get Excel to recognize that these values indeed match?

[ItsMe]

Maybe the Transferspreadsheet method or creating an Access object and manipulating it using the CopyFromRecordset method or creating and saving an Export procedure using the Wizard will help to remedy the issue.

[JeffGeorge]

After some further experimentation I was able to remedy this by using the "Match Destination Formatting" paste option. By doing that it seemed to ignore anything special that was coming from Access. Thanks for the help, though.