title: Excel Function checking street name in full addresses
body: <p>I have two sheets in excel, on containing full addresses and one containing street names. I need to create a lookup function that checks each full address to see if it contains one of the street names in the other sheet.</p>
  
  <p>Normally i would use this =VLOOKUP or =Countif function to return a value if the cell exist in the lookup matrix, but they both check the whole content of the cell. while i only need to see if it contains a specific part.</p>
  
  <p>Example cells would be.</p>
  
  <p>Full Adresse Sheet1 A1:</p>
  
  <p>Alpha street 34, fictional city Zip230</p>
  
  <p>Lookup Sheet2 columns A:</p>
  
  <p>Alpha Street</p>
  
  <p>Beta Street</p>
  
  <p>...</p>
  
  <p>trying to create a function that check if any string in Column A Sheet2 exisit inside the string in Sheet1 A1. Even better if the function is not case sensitive.</p>