Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

We're trying to create a query based off whether or not specific "Categories" have been selected. Here's an example of the categories they would select:

Channels
Arts & Entertainment (SELECTED)
Business, News & Finance (SELECTED)
Food, Home & Family
Style & Fashion
Tech (SELECTED)
Men's Lifestyle

In the query then, when we're calling the Column that links to that data we'd like it to read:

where Col4 contains 'Arts' or Col4 contains 'Business' or Col4 contains 'Tech'

The categories above live above the cell where the query call is being made.

share|improve this question
    
What do you mean by "calling the Column that links to that data" and what if any is the significance of "categories above live above the cell where the query call is being made"? –  pnuts Aug 14 at 21:46

1 Answer 1

I guess we may never know, but perhaps what was required was something like:

=QUERY(A2:D7,"Select * WHERE D contains 'Arts & Entertainment' or D contains 'Business, News & Finance' or D contains 'Tech' ")
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.