title: Vlookup to return multiple rows per customer
body: <p>I am working with Excel 2010 and have two worksheets.</p>
  
  <p>Sheet1 contains a list of customer e-mail addressses along with a unique customer name.
  D2 - Email addresses
  C2 - Customer Name</p>
  
  <p>Sheet2 contains a list of customers that are classed paying customers, it uses the same customer naming standard as sheet1.
  A2 Customer Name</p>
  
  <p>I need to link the two spreadsheets so can I identify which of the paying customers we have e-mail addresses for. I am not sure how to do this. In Sheet1 we have more than 1 email address per customer and I would like a central list of them all together even if we do not have an email address for the customer.</p>
  
  <p>Thanks for the help</p>