Google-sheets – Query a Google Spreadsheets using several different values

formulasgoogle sheetsgoogle-sheets-query

I'm trying to figure out how to update the following Google Spreadsheets query function so it can search column "J" for three or more separate values. If any of the values are present in column "J", I need the query to return the 'select' data in column B, C, D, etc.

=query(data!B2:BK,"select B, C, D, E, F, G, H, I, J, K, L, M, N, BA where J = 'Guest Speaker'",false)

So if "J" equals Guest Speaker or Field Trip or Anything, it will return data from B, C, D, etc.

Best Answer

As query language documentation says,

You can join multiple conditions using the logical operators and, or, and not. Parentheses can be used to define explicit precedence.


select * where J = 'Guest Speaker' or J = 'Field Trip' or J = 'Anything'