title: MATCH function does not work with numbers (only numbers) with wild cards (*)?
body: <p>I am trying to match pure numbers ending with *:</p>
  
  <pre><code>        A            B
  1     52778*      5477A9
  2     5477A*      527789
  </code></pre>
  
  <p>For example, I want to match A1 with B2, and the match function I used is:</p>
  
  <pre><code>=match(A1,B:B,0)
  </code></pre>
  
  <p>This should return the value of 2, but instead it gives me #N/A. </p>
  
  <p>However, I found that I can successfully match A2 with B1:</p>
  
  <pre><code>=match(A2,B:B,0)
  </code></pre>
  
  <p>This gives me the result of 1.... </p>
  
  <p>Is it because the wild card (*) does not work with pure numbers? How can I match  pure numbers with wild card then?</p>
  
  <p>Thanks.</p>