CODEWITHSUNDEEP
google-sheetsmatchspreadsheettextjoinmultiple-matches
zongshita
zongshita

Reputation: 191

How to use query function to exclude names based on criteria from another sheet?

How to use query function to exclude names based on criteria from another sheet ? Thank you

https://docs.google.com/spreadsheets/d/1Yl-oBui4ji6AzGg47FAe68fi2PqHTUC08kYhBMtB2DY/edit?usp=sharing

enter image description here

Upvotes: 1

Views: 962

Answers (1)

player0
player0

Reputation: 1

use:

=QUERY({A2:B}, "where not Col1 matches '"&TEXTJOIN("|", 1, Criteria!A:A)&"'")

enter image description here

Upvotes: 1

Related Questions