Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using FILTER() to display a value from Sheet 2 where the Name columns match.

My problem is where I want FILTER(Sheet2!A:F, Sheet2!A:A="Combat Medic" OR Sheet2!A:A="Universal"), as "OR" results in an error.

What is the correct syntax? Must I use a QUERY() instead?

Thanks for your time.

share|improve this question
Did my solution work for you? – Jacob Jan Tuinstra Apr 28 '13 at 19:06
You might also find this useful: Google Spreadsheets: Filter a range by array – Vidar S. Ramdal Nov 27 '13 at 12:18

Use the following formula to obtain the query you want.


=FILTER(A:A;(A:A="Combat Medic")+(A:A="Universal"))


In the reference it is explained by Ahab that + and * can be used as boolean expressions, as OR and AND.

The solution with the IFERROR (see revision history) is of no use in this case, unless you want to find a particular string:

=FILTER(Sheet2!A:F;IFERROR(FIND("Combat";A:A);0) + IFERROR(FIND("Uni";A:A);0))

Here the IFERROR returns 0 when nothing is found, causing the formula to still function.


enter image description here


I've modified the example file to contain both solutions: Filter with Boolean


Google Product Forum, Boolean Expressions

share|improve this answer
Interesting! Could you elaborate on how IFERROR(...) + IFERROR(...) works? – Vidar S. Ramdal Nov 27 '13 at 12:16
@VidarS.Ramdal How about it? – Jacob Jan Tuinstra Nov 27 '13 at 13:20
Great! Nice trick! – Vidar S. Ramdal Nov 27 '13 at 13:45
where is the documentation that '+' can be used as a boolean OR? – Chris Morris Aug 25 '15 at 12:57

Your Answer


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.