title: How to match text string in a cell approximately
body: <p>I've got this formula</p>
  
  <pre><code>=IFERROR(INDEX('[Fishing Contact list July 2015.xlsm]Places'!$A$2:$A$65, SMALL(INDEX(ROW($1:$64)+('[Fishing Contact list July 2015.xlsm]Places'!$Q$2:$Q$65="A"&amp;'[Fishing Contact list July 2015.xlsm]Places'!$B$2:$B$65&gt;="Fishing")*1E+99, , ), ROW(1:1))),"No Active Fishing Places")
  </code></pre>
  
  <p>which is designed to look in another workbook in column B for the word " Fishing" and return the names of the fishing places which are written in column A only if in column Q an A has been written and in column B the text matches the word Fishing. </p>
  
  <p>The problem I am having is that in column B there is not just the text Fishing. There is often, "Fishing/Lakes" or "Fishing/SaltWater" for example. I need a way of just using the word "Fishing" to find a match (as well as using A in column Q) without having to individually write out the words.</p>
  
  <p>At the moment it just returns "No Active Fishing Places". If I reverse the >="Fishing" to &lt;="Fishing" the value returned is 0.</p>
  
  <p>I have also tried fitting match into the formula which should have allowed me to use "Fishing*" but this did not seem to work either).</p>
  
  <p>Thanks in advance</p>