So, some background: I have a Google Sheets document with several sheets of information.
Two sheets hold data that needs to be checked against one another.
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).
Sheet B is a shorter list of names (all of whom are on Sheet A), a date and a dollar amount for each.
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.
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.
While this may not seem complex, I have been running into a lot of issues making this work.
example:
Sheet A: Contact data
Name | Street Address | City | Prov | Postal | Email |
John Smith | 123 Smith Lane | Smithtown | ON | x0x 0x0 | [blank] |
Jane Doe | [blank] | [blank] | [blank] | [blank] | [email protected] |
Tim Philips | 111 Philips Crt | Phillipston | ON | z2z 2z2 | [blank] |
Joe Test | [blank] | [blank] | [blank] | [blank] | [email protected] |
Sheet B: Donations
Name | Street Address | Email | Date received | Amount (2018)
John Smith | [blank] | [email protected] | 20/NOV/2018 | $175 |
Joe Test | [blank] | [email protected] | 15/OCT/2018 | $200 |
Sheet C: output for mail merging (Filter-sorted by email addresses)
Name | Address | Email | Date received | Amount (2018) |
Joe Test | [blank] | [email protected] | 15/OCT/2018 | $200 |
John Smith | 23 Smith Lane Smithtown, ON x0x 0x0 | [blank] | 20/NOV/2018 | $175 |
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
