title: Copying/pasting lookup values for a vlookup formula gives N/A, but typing values gives correct results
body: <p>I'm trying to get a VLOOKUP to pull results based on lookup values I copy and paste from another sheet. </p>
  
  <p>The formula works when I type the values in and hit enter, but when I copy a list of values into the column from another sheet the VLOOKUP returns an N/A value. Both the column of values and the column used for the VLOOKUP formula are formatted as 'Text' and pasting as a value hasn't worked. </p>
  
  <p>Does anyone know why this is happening? Or how to get around this?</p>
  
  <p>Formula for reference:
  =IF(VLOOKUP(A3,Data_Exported!$A:$CB,2,FALSE)=0,"",VLOOKUP(A3,Data_Exported!$A:$CB,2,FALSE))</p>