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.