Checkbox filtering using words instead of numbers True/False

[PuntingJawa]

I am fairly new to excel so please bare with me. I'm trying to make a checkbox in B2 create the "True/False" in A2. Then trying to make A2 activate a filter in all of C through F cells where True activates the filter for a specified word and False removes the filter. In this case I'm creating a filter for candy. So say the candy is Sweet, Salty, and Milk Chocolate. I want to be able to check the boxes with "Sweet" "Salty" "Chocolate" and have it pull up the products with the flavor combination. Is this even possible? I'll upload my data sheet when I get home in two hours on what it currently looks like.

 

[PuntingJawa]

Beaker Project 2.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Flavors		Chocolate Type			Product	Flavor 1	Flavor 2	Flavor 3	Flavor 4	Chocolate type
2
3	TRUE		TRUE			Candy Club: Spring Twists - Limited Edition	Sweet	Salty	MILK	CRUNCHY	CHOCOLATE
4	TRUE		TRUE			Candy Club: PB Malt Balls - Limited Edition	SWEET	PEANUT BUTTER	CRUNCHY
5	TRUE		TRUE			Candy Club: Mint Bunny Bark - Limited Edition	CRUNCHY	SWEET	WHITE
6	TRUE					Candy Club: Eggstra Special - Limited Edition	GUMMY	FRUITY	SWEET
7	TRUE					Candy Club: Creamsicle Taffy - Limited Edition	CHEWY	FRUITY	SWEET
8	TRUE					Candy Club: Coconut Haystacks - Limited Edition	CHOCOLATE	MILK	CRUNCHY
9	TRUE					Candy Club: Bunny Buddies - Limited Edition	FRUITY	CHEWY	SWEET
10	TRUE					Sugar Free Milk Chocolate Coated Almonds	CHOCOLATE	MILK	CRUNCHY
11	TRUE					Sugar Free Dark Chocolate Coated Almonds	CHOCOLATE	Dark	CRUNCHY
12	TRUE					Cinnamon Roasted Almonds	CINNAMON	crunchy	Sweet
13	TRUE					Cinnamon Roasted Cashews	CINNAMON	crunchy	Sweet
14	TRUE					Cinnamon Roasted Pecans	CINNAMON	crunchy	Sweet
15	TRUE					Premium Slushy Mix - Watermelon	Sweet	Fruity
16	TRUE					Premium Slushy Mix - Pomegranate	Sweet	Fruity
17	TRUE					Premium Slushy Mix - Raspberry	Sweet	Fruity
18	TRUE					Premium Slushy Mix - Pina Colada	Sweet	Fruity
19	TRUE					Premium Slushy Mix - Strawberry Daiquiri	Sweet	Fruity
20	TRUE					Premium Slushy Mix - Peach Mango	Sweet	Fruity
21	TRUE					Premium Slushy Mix - Sangria	Sweet	Fruity
22						Premium Slushy Mix - Cranberry Acai	Sweet	Fruity
23						Premium Slushy Mix - Margarita	Sweet	Fruity
24						Premium Slushy Mix - Blood Orange	Sweet	Fruity
25						Compartes: Vegan Organic Blueberry Almond Dark Chocolate Bar - Beauty	Chocolate	DARK	FRUITY
26						Compartes: Vegan Organic 80% Pure Cocoa Dark Chocolate Bar - Pure	Chocolate	dark
27						Compartes: Vegan Organic Mixed Nuts Sea Salt Dark Chocolate Bar - Energy	Chocolate	DARK	NUTTY
28						Compartes: Vegan Organic Strawberry Goji Acai Dark Chocolate Bar - Superfood	CHocolate	DARK	FRUITY
29						Compartes: Caramel Crunch Milk Chocolate Bar	Caramel	Milk	Chocolate
30						Compartes: Old Hollywood Smoked Sea Salt Dark Chocolate Bar	Salty	Chocolate	Dark
31						Compartes: Coffee Crunch Dark Chocolate Bar	Coffee	Crunchy	Chocolate	Dark
32						Compartes: Chocolate Chip Cookies Milk Chocolate Bar	Chocolate	crunchy	MILK
33						Compartes: Peanut Butter and Jelly Milk Chocolate Bar	Chocolate	Crunchy	Nutty	Peanut Butter
34						Compartes: Blonde Bombshell Strawberry Champagne Dark Chocolate Bar	Chocolate	Fruity	Dark
35						Compartes: Tiramisu Milk Chocolate Bar	Coffee	Milk	Chocolate
36						Compartes: California Love Dark Chocolate Salted Pretzel Bar	Salty	Chocolate	DARK	Crunchy
37						Compartes: Raspberry Rose Dark Chocolate Bar	Chocolate	dark	fruity
Filter

 

[PuntingJawa]

This was never solved. How ever I did manage to make it work using Slicers which actually was pretty nice looking. I just had to step back and quit thinking on more complicated measures.