title: Python extracting excel cells
body: <p>I'm reading hundreds of excel files and searching for a string then the value next to that string. The problem I'm facing is that the string is rarely in the same cell. As an example: </p>
  
  <p>Sheet 1</p>
  
  <pre><code>        Name             Amount
          foo              15
          bar              23
          bin              10
  </code></pre>
  
  <p>Sheet 2</p>
  
  <pre><code>        Name             Amount
          bin              28
          foo              10
          bar              6
  </code></pre>
  
  <p>I would like to read the files, and write | foo | # | in another excel sheet with each instance being a new line. </p>
  
  <p>I'm struggling with an approach to take.</p>
  
  <p>Desired output</p>
  
  <pre><code>       Name            Amount
         foo             15
         foo             10
  </code></pre>