title: Find cells within a range if one cell equals a criteria copy its value to another column
body: <p>I'm having real trouble trying to get this to work for me. To help explain what I need to do I've produced a (hopefully) very simple example below...</p>
  
  <p>What I would like to do is:</p>
  
  <ul>
  <li>Within a range of cells <code>A:A</code> find <code>J Bloggs</code> (note there can be multiple entries and I need all of them)</li>
  <li>When an order from <code>J Blogs</code> is found copy his order date <code>B1</code>, request del. date <code>C1</code> and actual del. date <code>D1</code></li>
  <li>Paste this information into a table <code>G1:J4</code></li>
  </ul>
  
  <p>NB: The list of customers can be long, and some customers may make seperate orders. I need to generate a list of all of these orders (don't need to check if date is in the past etc.).</p>
  
  <p>Each time the query is run, say this time for <code>H Simpson</code>, only the details for <code>H Simpson</code> will appear in the table <code>G1:J4</code>  </p>
  
  <pre><code>+---------------+----------------+---------------------+------------------+  
  |   Customer    |   Order Date   | Requested Delivery  | Actual Delivery  |  
  +---------------+----------------+---------------------+------------------+  
  | J Bloggs      | 01/01/2013     |  02/01/2013         |  02/01/2013      |  
  | H Simpson     | 05/01/2013     |  08/01/2013         |  09/01/2013      |  
  | A Name        | 10/01/2013     |  10/01/2013         |  10/01/2013      |   
  | J Bloggs      | 15/01/2013     |  22/01/2013         |  22/01/2013      |  
  +---------------+----------------+---------------------+------------------+
  </code></pre>