title: Excel find cells from range where search value is within the cell
body: <p>Once again I'm struggling to find my answer on Google, but I'm sure it must exist.  Sorry if I come across as a novice: I am when it comes to Excel it seems!</p>
  
  <p>What I'd like to be able to do is tell it to search a range, then find cells within that range that contain text that is in my search function.  I don't need any kind of result from it other than either TRUE or >1 (if it matches, obviously).</p>
  
  <p>In this instance I'm searching a RANGE that is comprised of years, one year in each cell, and trying to find cells in that range that contain a year from a list of years that are all in one cell.</p>
  
  <p>Basically I'm wanting to use a function similar to the Search function I think.</p>
  
  <pre><code>=SEARCH(text to find, find within text)
  </code></pre>
  
  <p>However, I'd like it to do the opposite and find cells that contain some of the text within the source cell:</p>
  
  <pre><code>=SEARCH(find within text, text to find)
  </code></pre>
  
  <p>Or, more specifically</p>
  
  <pre><code>=SEARCH("2001,2002,2003,2004,2005", "2003")
  </code></pre>
  
  <p>Is this possible without the use of a Macro?  I'd prefer to avoid it if at all possible.  All cells in question are formatted as Text.</p>
  
  <p>I have been experimenting with COUNTIF, but again it works in the reverse of what I need. </p>
  
  <p>Sorry if this question is unclear.
  Hope someone can help, thanks in advance.</p>
  
  <p>Joe </p>