title: What is the significance of the question mark in Excel?
body: <p>If I type in this formula:</p>
  
  <pre><code>=vlookup(A1,LetterTable,2,False)
  </code></pre>
  
  <p>With A1 set to "?" (without the quotes), and LetterTable contains this:</p>
  
  <pre><code>a   a
  b   b
  c   c
  ...  ...
  -   -
  +   +
  ?   ?
  !   !
  </code></pre>
  
  <p>It always gives me "a" (no quotes). Why is this? </p>
  
  <p>Also, if I copy that into an array in vba and loop through it, comparing it to the spreadsheet value, it won't find it either.</p>