Search by selected rows in multi-select fields

This page did not load. You can still read it on the original site — the toolbar below keeps your place in the directory.

I have data like this. Column A is item , column B are tags . Col A Col B res1 tag1, tag2 res2 tag1, tag3 res3 tag3, tag4 res4 tag4, tag5 res5 tag11, tag5 Then I have table with possiblity to mark interesting tags: Col C Col D x tag1 x tag3 tag5 The result I want to get is list of items from Col A that have tags from column D marked with x in column C. I've tried multiple ARRAYFORMULA and QUERY…

Read on webapps.stackexchange.com ↗