yogi_Query Items From Column A Based On Items Check Marks In C2:E2

Google Spreadsheet   Post  #2533

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-04-2018

question by: Ivan LD
https://productforums.google.com/forum/#!topic/docs/bVM7DBwnSXI;context-place=forum/docs

Query with checkbox
Hi  Im trying to get a query result based on checkbox selection but i cant seem to get the proper formula here's what i got but it as error

=Sort(query(A4:A24,"select * where A is not null "&IF(C2=True," and A = '"&C1&"' or "&if(D2=True," and A = '"&D1&"' ",)&if(E2=True," and A = '"&E1&"' ",))),1,True)

the query returns with #value 

          A                        B                                C                                D                      E

		Apple	Banana	Orange
		☑	☑	☐
Item		Query Result
Orange		Apple
Apple		Apple
Apple		Apple
Apple		Apple
Banana		Apple
Orange		Apple
Apple		Apple
Orange		Apple
Apple		Banana
Banana		Banana
Banana		Banana
Banana		Banana
Orange		Banana
Orange		Banana
Apple
Banana
Apple
Banana
Apple
Orange
Orange

Here's a link to my page thanks

https://docs.google.com/spreadsheets/d/1nK5-jz0iYpKF6zcbbLuM0eJkVXWK7Y4SGODSCMvGHGI/edit?usp=sharing