title: Vlookup but return sheet name if found
body: <p>Currently, this will return &quot;Yes&quot; (which is in the 6th column) or &quot;Not Found&quot;.  Would it be possible to return the sheet name if true?</p>
  <p>Thanks in advance.</p>
  <pre><code> =IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;1eMzpzOJBDmrJfxqHTqEcllK8lFIN8C8fSkQUpZY1gJM&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false),
  IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;179IscQOWpn7W1GPH5RSK4sc8zxUS2Ll3AoIwkxEPOX4&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false),
  IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;1Xv0cjLgT_20ETSsWL031ybSvqG3onZlKMYXrLWiR1vc&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false),
  IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;1Yjp-AVuuKYMNonUADc37h0CInN9cr7GCnxx0wIwoaY4&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false),
  IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;1d1rGCzi8W975i__wZ-7RcuXMmWFXYjg5sZTceLDjgRw&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false),
  IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;1ve8EAw3OMf_xRofRgRa6vBPGA3P72Gk8E77yrGFXyF8&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false),
  IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;17-NKDd-WCO_XE0zXEwEcZ8CGHrB_cRIHg7wHnMnrIt4&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false),
  IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;1bI2W5b3-WlgLe401enLpt9hqqjxvD41zMsU2gSGUsaQ&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false),
  IFERROR(VLOOKUP(A2,IMPORTRANGE(&quot;1Zn75yae3XVhXxQEDLuG3gCZjkce2HDcxUaVDEfJmgck&quot;, &quot;Current Roster (Master)!A2:H&quot;),6,false), &quot;Not Found&quot;)))))))))
  </code></pre>