title: Give column A when you find text string in column B
body: <p>I have two sheets. One sheet contains column <code>A</code> and column <code>B</code>.  <code>A</code> contains names, <code>B</code> contains a list of names. My second sheet contains names where I need to find if any of the names in my second sheet appear in column <code>B</code>, and if they do, what is the name in column <code>A</code>.</p>
  
  <p>For example:</p>
  
  <p>Sheet1:</p>
  
  <pre><code>A1: Nancy
  B1: Kyle (243), Jack (524), Foster (4352)
  A2: Bill
  B2: Cathy (23423), Tim (1019)
  </code></pre>
  
  <p>Sheet2:</p>
  
  <pre><code>A1: Kyle (243)
  B1: Nancy
  A2:Tim (1019)
  B2:Bill
  </code></pre>
  
  <p>I know how to use vlookup/index/match when the text matches exactly. But I can't get it to approximate search for text string correctly. Countif can only tell me, yes, that search string exists in that column but not which row. Any assistance would be greatly appreciated! </p>