title: VLookup throws errors for some values but not others
body: <p>VLookup is throwing an error when I search for some string values and not others:</p>
  
  <blockquote>
    <p>Run-time error '1004': Unable to get the VLookup property of the Worksheet Function class</p>
  </blockquote>
  
  <p>Apparently this error indicates that there was no value found BUT to my human eye the values match!  </p>
  
  <p>Is this the result of a hidden character or a space or something I can't see?  </p>
  
  <p>How do I go about ensuring that values on one page are actually the same as values on another?</p>
  
  <p>Also, I thought that maybe I'm not searching where I think I'm searching which would explain why I can't find some of the values. As a test I changed the return value in the column and the change came back correctly. Then I change the lookup value which should have thrown an error but it didn't. It returned a different value instead. I searched for "United States" which isn't there and instead it returned the value for "United Kingdom" instead.</p>