1

I have two different google sheets; one with the leads data and the other with unsubscribe data. Is there a way to automatically update the lead's data whenever a new unsubscribe email is added to the unsubscribe sheet? If the leads data has any email which is in the unsubscribe list, the data related to that email should be automatically removed.

Here is the sheet with sample data: https://docs.google.com/spreadsheets/d/1zhPRjQnrsD7B51ig7M5G8LnYte_3h07jx6pRNXnCSM4/edit#gid=2100307022

Thanks in advance for the help!

Improve this question
1
  • Welcome to Web Applications Stack Exchange. Please edit your question and insert two tables that show a sample of leads data and unsubscribe data, together with a third table that shows your manually entered desired results. Also consider sharing a publicly editable sample spreadsheet. There is a blank sheet maker that lets you share safely.
    – doubleunary
    Commented Jan 4, 2023 at 17:13

1 Answer 1

Reset to default
1

Use filter() and match(), like this:

=filter( A4:C8, isna(match(A4:A8, A11:A15, 0)) )
Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.