My issue is as followed:

I have 4 categories...1,2,3,4

Set criteria for each..."tomatoes = "" By filtering 1 it would give me
"red", 2 would give me "green" so on....

This is for multiple criterias....HOW DO I DO IT???? I can build 4
different sheets but I'd rather have 1 sheet and click on the Subject and
have it change the values from there.
Thank you,