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.