I have a spreadsheet with a column of names, email addresses and organizations. I want Excel to find each name in a column on a separate sheet, find its organization, and return yes if organization contains specific text.
For example:
Sheet 1
Sheet 2
Thanks in advance!
For example:
Sheet 1
Name | Organization | |
John Doe | johndoe@email.com | ACME Incorporated |
Jane Patel | janepatel@email.com | |
Melissa Williams | melissawilliams@email.com | |
Eric Smith | ericsmith@email.com | Amazon |
Erica Williamson | ericawilliamson@email.com | ACME Company |
Sheet 2
Name | ACME? | |
John Doe | johndoe@email.com | Yes |
Jane Patel | janepatel@email.com | No |
Melissa Williams | melissawilliams@email.com | No |
Eric Smith | ericsmith@email.com | No |
Erica Williamson | ericawilliamson@email.com | Yes |
Thanks in advance!