title: Need to do complex lookups and referencing of data across differently sized samples in Google Sheets
body: <p>So, some background: I have a Google Sheets document with several sheets of information. </p>
  
  <p>Two sheets hold data that needs to be checked against one another. </p>
  
  <p>Sheet A is a list of contact data (and many other columns of classifying data that is irrelevant to this process, but makes it difficult to do all of this with a single sheet).</p>
  
  <p>Sheet B is a shorter list of names (all of whom are on Sheet A), a date and a dollar amount for each.</p>
  
  <p>When data is entered into B, we enter either the street address or email they provide us at the time as a way of ensuring that two people with the same name do not get mis-matched. If an email is provided, we try to use that.</p>
  
  <p>I need to create a third sheet (C) for easily displaying the data from B with the contact information of the corresponding names stored in A.</p>
  
  <p>While this may not seem complex, I have been running into a lot of issues making this work. </p>
  
  <hr>
  
  <p>example:</p>
  
  <p>Sheet A: Contact data</p>
  
  <p>Name   |   Street Address   |   City   |   Prov   |   Postal   |  Email   |</p>
  
  <p>John Smith  |  123 Smith Lane  |  Smithtown  |  ON  | x0x 0x0  |  [blank]  |</p>
  
  <p>Jane Doe  | [blank]  |  [blank]  | [blank]  |  [blank] |  Doe@doecorp.co  |</p>
  
  <p>Tim Philips  |  111 Philips Crt  |  Phillipston  |  ON  |  z2z 2z2  |  [blank]   |    </p>
  
  <p>Joe Test  | [blank]  |  [blank]  | [blank]  |  [blank] |  Joe@testorg.ca  |</p>
  
  <hr>
  
  <p>Sheet B: Donations</p>
  
  <p>Name   |   Street Address   |   Email   |   Date received   |   Amount (2018)</p>
  
  <p>John Smith  |  [blank]  |  smith@smithorg.org  |  20/NOV/2018  |  $175  |  </p>
  
  <p>Joe Test  |  [blank]  |  joe@testorg.ca  |  15/OCT/2018  |  $200  |  </p>
  
  <hr>
  
  <p>Sheet C: output for mail merging (Filter-sorted by email addresses)</p>
  
  <p>Name   |   Address   |   Email   |   Date received   |   Amount (2018)  |</p>
  
  <p>Joe Test  |  [blank]  |  joe@testorg.ca  |  15/OCT/2018  |  $200  | </p>
  
  <p>John Smith  |  23 Smith Lane  Smithtown, ON  x0x 0x0  |  [blank]  |  20/NOV/2018  |  $175  |   </p>
  
  <hr>
  
  <p>Ideally, the individual mailing address fields from A would be pulled and combined into a single cell in the end result. (we use the others to sort and filter our data</p>