I want to query a range of cells, using another range as the criterion. Is this possible?Something like this:QUERY('Current Schedules'!A5:F154, Select F where A = '&A13:A15&' )Where A13:A15 are three names. I would preferably replace the &A13:A15& with another query that returns an array of names, but I need to get this working with an array of criteria first.
Can I query a range of cells that match the criteria of another range of cells in Google Spreadsheets?
google spreadsheets