title: Find string in substring with vlookup in Excel
body: <p>I have an excel sheet with names of flowers, for example:</p>
  
  <ul>
  <li>Polygonum amphibium</li>
  <li>Hippuris vulgaris</li>
  <li>Lysimachia vulgaris</li>
  <li>Juncus bulbosus ssp. bulbosus</li>
  <li>Lycopus europaeus ssp. europaeus</li>
  <li>Nymphaea alba</li>
  </ul>
  
  <p>Now I need to find these Names in another table which is not so specific. For example: <strong>Juncus bulbosus ssp. bulbosus</strong> needs to be find in an Excel sheet where it is called "<strong>Juncus bulbosus*</strong>".</p>
  
  <p>I know that it is possible to use the <code>*</code> as wildcard. So I can use vlookup to find <strong>Juncus bulbosus*</strong> in <strong>Juncus bulbosus ssp. bulbosus</strong>.  </p>
  
  <p>But is it possible to do it vise versa and find <strong>Juncus bulbosus ssp. bulbosus</strong> in <strong>Juncus bulbosus*</strong>?</p>