title: VLOOKUP not working in excel for MAC 2011
body: <p>I have a problem when using VLOOKUP in excel for MAC 2011. I am looking up for a value two column in different sheet, Column A is the one I want to check, Column B is the reference.</p>
  
  <p>=VLOOKUP(A1, Sheet2!$A$1:$B$1000,2,0)</p>
  
  <p>Some of boxes in Column A get a value return, but the other cannot. For those which cannot, when I retype the words inside the box, and I get the value returned.
  I try to copy the Column A and selectively paste with value only, but those cannot get a returned value remained the same. </p>
  
  <p>I guest there is something wrong with the format, but I cannot fix it. Please help.</p>