title: True/false check across multiple google sheets with 2 criteria
body: <p>So I've been trying to find a way to check multiple sheets on a column on the master sheet.</p>
  <p>Previously the different sheets used a mixture of importrange and index/match to match town(each sheet is a different one)/number and pull a separate, matching columns number into said sheet.</p>
  <p>=IF(B9&gt;0,IFNA(INDEX(IMPORTRANGE(&quot;MAINSHEETLINK&quot;,&quot;Civils!$J$5:$J$500&quot;), MATCH (B9,(IMPORTRANGE(&quot;MAINSHEETLINK&quot;,&quot;Civils!$I$5:$I$500&quot;))*(IMPORTRANGE(&quot;MAINSHEETLINK&quot;,&quot;Civils!$D$5:$D$500&quot;)=$P$7), 0)),0),&quot;0&quot;)</p>
  <p>the $P$7 is the town name on the row it searches for.
  The ifna just keeps it clean.</p>
  <p>I can't figure out how I can use vlookup or query to search multiple sheets in this way. There's a separate Yes/No check on the secondary sheets that checks whether or not something was imported. I'd like a separate column on the main sheet to check across multiple sheets to true/false if the above check is Yes/No.</p>
  <p>There's a possibility I have several nested if functions working through each sheet using the above index/match, but that seems prone to breaking, not to mention having to redo it once new sheets crop up.</p>