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&"' ")
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.