Google sheet import range, filter via query on contain basis-CodePudding

Home > Net > Google sheet import range, filter via query on contain basis

Google sheet import range, filter via query on contain basis

Time：04-07

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.

CodePudding user response：

Try

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