CODEWITHSUNDEEP
google-sheets
bd528
bd528

Reputation: 886

Filter / Match - Returning Not Found

I have the following Google Sheets formula, which returns where values in Source!D1:D are found in Data!A1:A :-

=sort(filter(Source!A1:AD, match(Source!D1:D, Data!A1:A, 0)),1,1)

Is it possible to have Sheets do the opposite, so return everything except where values in Source!D1:D are found in Data!A1:A?

I've tried 

=sort(filter(Source!A1:AD, match(Source!D1:D, <>Data!A1:A, 0)),1,1)

but that returned an error

Upvotes: 0

Views: 41

Answers (1)

JPV
JPV

Reputation: 27262

See if this works:

=sort(filter(Source!A1:AD, isna(match(Source!D1:D, Data!A1:A, 0))),1,1)

Upvotes: 1

Related Questions