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

CodePudding user response：

use:

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