How to exclude phone numbers from one Google Sheets tab using data from another tab

Other Questions Google Sheets
1

I’m working with two Google Sheets tabs and need help with filtering data between them.

In the first tab (let’s call it Campaign List), I have a column full of phone numbers that I used for marketing messages. In the second tab (Response List), I have phone numbers of people who responded to those messages.

What I want to do is create a list that shows only the phone numbers from Campaign List that are NOT found in Response List. Basically, I need to identify which contacts didn’t respond so I can follow up with them.

Both tabs have a simple structure with just one column containing phone numbers. I know in databases you could use something like NOT EXISTS or similar logic, but I’m not sure what formula or method works best in Google Sheets for this type of comparison.

Can someone point me in the right direction? I’d appreciate any suggestions on how to accomplish this filtering task.

2

try using =FILTER(A:A, ISERROR(MATCH(A:A, ‘Response List’!A:A, 0))) itll give you the phone numbers you need from Campaign List that aren’t in Response List. super handy for follow ups!

3

VLOOKUP with ISNA works great here too. Put =VLOOKUP(A2,‘Response List’!A:A,1,FALSE) in a helper column next to your Campaign List numbers. It’ll return the number if it’s in Response List, or throw an error if it’s not. Wrap that with ISNA to get TRUE for non-responders: =ISNA(VLOOKUP(A2,‘Response List’!A:A,1,FALSE)). Copy it down and filter for TRUE - boom, there’s your follow-up list. I’ve done this for similar marketing cleanups and it’s solid, just watch for formatting differences in your phone columns since that’ll break the matches.