title: MS Excel: Find First Occurrence of Specific Text within a String Using Column Range List
body: <p>Using a MS Excel formula that finds and extracts the very first (1st) instance/occurrence of a specific word found within a Column range of Keywords.</p>
  
  <p>In Cell A2 I have a sub-string of text containing the following:</p>
  
  <p>Karen was born in Akron, OH and attended college in Mobile, AL before moving to Atlanta, GA soon after her parents retired and now lives in Raleigh, NC.</p>
  
  <p>Column B2:B10 (List of City &amp; State keywords in a column list)  </p>
  
  <pre><code>Tulsa, OK  
  New York, NY  
  Boise, ID  
  Atlanta, GA   
  Baltimore, MD  
  Raleigh, NC  
  Pittsburgh, PA  
  Akron, OH  
  Mobile, AL
  </code></pre>
  
  <p>I've attempted to use the following formula's but without success.</p>
  
  <pre><code>=IFERROR(INDEX($B$2:$B$10,MATCH(TRUE,COUNTIF(A2,"*"&amp;$B$2:$B$10&amp;"*")&gt;0,0)),"")
  </code></pre>
  
  <p>-AND-  </p>
  
  <pre><code>=IFERROR(INDEX($B$2:$B$10,MATCH(TRUE,ISNUMBER(SEARCH"*"&amp;$B$2:$B$10&amp;"*",A2)),0)),"")
  </code></pre>
  
  <p>Both Results Returned: Mobile, AL</p>
  
  <p>Expected Results:</p>
  
  <p>Correct Results = Akron, OH</p>
  
  <blockquote>
    <p>Note: Although there are four possible matching results, instead it matches and retrieves/extracts Akron, OH, as it searches and finds the keyword position from Right to Left.</p>
  </blockquote>