Google Sheets Query Non-Contiguous Range
<p>Is it possible to write a query (inside a formula) that references non-adjacent (discontinuous, discontiguous, I don't know the proper phrase) ranges? For instance: =query(A2:C,E2:F,"Select Col2 where Col5=3")</p>

<p>I want to be able to put my query in Column D, so I wanted to split the range around it.  If I just say "Query(A2:F..." it will detect circular dependency when the equation is in Column D.  </p>

<p>If it helps, I have shared a <a href="https://docs.google.com/spreadsheets/d/1ORNeprrvlcA2iGULqi1L8kxGSthmhCzTxGpidI2ioeM/" rel="noreferrer">spreadsheet</a> with an example (highlighted in yellow): </p>