I Have this sheet with raw data, basically names, dates, amounts of money and if they paid or not (this is the most important). What I am trying to do is to have in another sheet the same table but showing the rows of the people who hasn't paid (filter by a "NO" in "paid" column), and if in the Raw data sheet the value in Paid is changed from NO to YES that row disappears in the "Filtered" sheet.

I am trying to make a VLOOKUP in a query but with no success, any help?

Example Sheet.

1 Answer 1


Please try:

=query(Data!A1:D7,"select * where B ='NO' ")
  • thanks!! I'm constantly dealing with problems like this, do you know of any tutorial on Google query language? Feb 4, 2015 at 15:00
  • sorry to bother you (again), but what if I need to filter also by "type of client" (just saying)? Feb 4, 2015 at 15:24
  • haha just added another condition "where XXX and XXX" didn't know it was possible Feb 4, 2015 at 16:02
  • @elunicotomas Refer to this helpful document. Also please note that Google's query language is based on SQL, so that may help with some cases.
    – BlueBuddy
    Feb 4, 2015 at 21:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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