QUERY for two columns

Question

I am trying to use one query to search in two nonconsecutive columns.
So far I have the below formula.

=QUERY(combine!A1:D,"SELECT * WHERE LOWER(A) LIKE LOWER("""&B1&""") or SELECT * WHERE LOWER(D) LIKE LOWER("""&B1&""")",1)

But I want to type in B1 different names that might be in column A or column D and there might be more than 20 rows with that name.

Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. — marikamitsos, Dec 31, 2019 at 1:20

Rubén · Accepted Answer · 2019-12-31 00:27:47Z

1

The SELECT and WHERE keywords should be included only once.

Try

=QUERY(combine!A1:D,"SELECT * WHERE LOWER(A) LIKE LOWER("""&B1&""") or LOWER(D) LIKE LOWER("""&B1&""")",1)

answered Dec 31, 2019 at 0:27

Rubén♦

44.6k18 gold badges91 silver badges291 bronze badges

Add a comment |

1 Answer 1