I am using below formula to import data from another sheet
=QUERY(IMPORTRANGE(“URL”,”Sheet1!I:S”),”select * where Col1 = ‘May-24′”)
Need to add one more condition as Col2 = ‘USA'”
How can we use filters? or any other solution for this
=QUERY(IMPORTRANGE(“URL”,”Sheet1!I:S”),”select * where Col1 = ‘May-24′”)
New contributor
Pranav K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.