title: Vlookup with wildcard not working (partial string match) on long values
body: <p>I understand the basic use of the <code>vlookup</code> with wildcard but I'm running into a problem lately.</p>
  
  <p>I need to lookup a value that contained in a cell as a part of string. In the below Sample I look up colA in the colC, with should be found, then return the values in <code>col D</code> into <code>col B</code>.</p>
  
  <p>I use <code>=VLOOKUP("*"&amp;A1&amp;"*",C$1:D$2,2,0)</code>, and it only works for <code>B1</code>.</p>
  
  <p>Why do <code>B2</code> &amp; <code>B3</code> don't work out the same way? Any solution?</p>
  
  <p>Sample:</p>
  
  <p><img src="https://i.stack.imgur.com/Kkorg.png" alt="Sample"></p>