title: Display value if text strings from two ranges match
body: <p>I have two worksheets in Excel. One contains the rankings:</p>
  
  <p><img src="https://i.stack.imgur.com/yiEFW.png" alt="enter image description here">:</p>
  
  <p>The other one the matchups (daily updated automatically)</p>
  
  <p><img src="https://i.stack.imgur.com/AOrQS.png" alt="enter image description here"></p>
  
  <p>The purpose is to display the rank of each respective team in two columns next to the matchups. One of the problems is that the text strings are not exact matches (limitation of the webquery). </p>
  
  <p>So I need to find a formula for when there is a string of the table in Rankings that approximately matches the specified cell for the team in matchups <em>and</em> then display Rank (column 1 on Rankings) next to it.</p>
  
  <p>So far I've got this in the cell where the ranking is supposed to go.</p>
  
  <pre><code> =VLOOKUP("*"&amp;qry!B5&amp;"*";Sheet1!A3:C369;1;0)
  </code></pre>
  
  <p>But it just results in the string "rank" from the table header in Rankings.</p>
  
  <p>Any ideas?</p>