CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-sheets-formula
Asif Sheikh
Asif Sheikh

Reputation: 87

Google sheet import range, filter via query on contain basis

I am using import range using query filter on Google Sheets

=QUERY(IMPORTRANGE("range"),"WHERE COL1 = 'SUNBURN'")

I want the filtered range at the destination should also show the records of the main sheet containing burn or sun in its Col1.

In a nutshell, I want the filter to work on 'Contain' basis rather than Exact Match.

Upvotes: 1

Views: 737

Answers (1)

Mike Steelson
Mike Steelson

Reputation: 15318

Try

=QUERY(IMPORTRANGE("range"),"WHERE Col1 contains 'SUN' or Col1 contains 'BURN' ")

Upvotes: 1

Related Questions