title: Search on multiple sheets and return first row/header
body: <p>I'm trying to create inventory locator while searching through multiple sheets</p>
  <pre><code>'url01','sheet1'
  Rack 1  | Rack 2  | Rack 3  | Rack 4  |
  --------+---------+---------+---------+
  item01  | item03  | item05  | item09  |
  item02  | item06  | item04  | item07  |
  item08  |         |         | item10  |
  
  'url01','sheet2'
  Rack 1  | Rack 2  | Rack 3  | Rack 4  |
  --------+---------+---------+---------+
  item11  | item13  | item15  | item19  |
  item12  | item16  | item14  | item17  |
  item18  |         |         | item20  |
  </code></pre>
  <p>searching for item and return the Rack number/header</p>
  <pre><code>'url02','sheet1'
  Item    | Rack#  |
  --------+--------+
  item11  | Rack 1 |
  item05  | Rack 3 |
  item15  | Rack 3 | ... and so on
  </code></pre>
  <p>Using <code>=INDEX</code> <code>=INDEX(IMPORTRANGE(&quot;url01&quot;,&quot;sheet1!1:1&quot;),MAX(IF(IMPORTRANGE(&quot;url&quot;,&quot;sheet1!A$2:D$100&quot;)=A2,COLUMN(A2:D100),0)))</code></p>
  <p>I was able to get locations on single sheet, but I'm looking for a way to automatically search multiple sheets and return their location.</p>
  <p>If this is possible</p>
  <p>B'rgrds,</p>