How to use QUERY to show data in Google Sheet using tags

Question

I have a Google Sheet with 2 sheets. In sheet 01 I have this table.

In sheet 02 I want to have a "Search by Tag" sheet. So, googling I got this formula

=QUERY('01'!A2:D4, "select B,C,D where A = 'Yellow' order by B")

But I have 2 problems here:

1.- I need the formula to take the data from A2, under "Search Tag". As you can see, I have to write directly the tag name into the formula.

2.- I need the formula to find at least one of the tags in the same cell. For example, if I look for "red", it will show "Red Computer" data.

Answer 1

In your Sheet 02 you should use:

• cell A2: (Your Search Tag)
• cell B2: =QUERY('01'!A2:D4, "select B,C,D where A like '%"&A2&"%' order by B",0)

Answer 2

You can use IF with a REGEXMATCH function or FILTER for the same result without QUERY.

If you really want a Query, here's a fix :
1 -

Try this instead

=QUERY('01'!A2:D4, "select B,C,D where A = '"&A2&"' order by B")

2-

Can you explain your needs a little more, with a screenshot of expected result perhaps ?

Answer 3

• paste this in B1 cell:

  =QUERY(01!A:D, "select B,C,D where lower(A) contains '"&LOWER(A2)&"' order by B", 1)