title: Search sheet for multiple matches in a single row
body: <p>I would like to modify the following <code>QUERY</code>, or some formula variation that accomplishes the same result, to only be entered a single time at the top of the column and fill the cells below using <code>ARRAYFORMULA</code></p>
  
  <pre class="lang-excel prettyprint-override"><code>=IFERROR(QUERY(Items!$A$2:$T,"SELECT E,F,G,H,I,J,K,L,M,N,O,P,Q,R where A = '"&amp;Estimate!A2&amp;"' and B = '"&amp;Estimate!B2&amp;"' and C = '"&amp;Estimate!C2&amp;"' "&amp;if(Estimate!D2&lt;&gt;"", "and D = '"&amp;Estimate!D2&amp;"'",)&amp;" AND A is not null LIMIT 1", 0),"")
  </code></pre>
  
  <p>My formula is in Estimate!G2 of <a href="https://docs.google.com/spreadsheets/d/1Za3a9d3hKJCMAxy72sIRH9L61wLwvBw02Fwj_9E_z-4/edit#gid=2018079146&amp;range=G2" rel="nofollow noreferrer">my spreadsheet</a>.</p>