I am new to this forum and excited that I found it. My question might be simple, but it is driving me crazy. I have a workbook that uses vlookup to retrive data from another worksheet within that workbook. I import a list of numeric data into the first worksheet but the vlookup cells show #NA. If I enter the data into the cell, the vlookup works correctly. Why would the vlookup work correctly when the data is keyed but not work correctly when the data is pasted? If there anyway to fix this problem?: