title: QUERY which outputs a hyperlink to a cell in another tab in the same sheet
body: <p>In Google Sheets, I'm trying to write a QUERY which outputs a column displaying a hyperlink which links you to the cell pulled in by the QUERY, in another tab on the same sheet. </p>
  
  <p>Example (all within the same Sheet):</p>
  
  <p><strong>Tab 1:</strong></p>
  
  <pre><code>**Name**
  Chandler
  Ross
  Joey
  </code></pre>
  
  <p>Utilizing the hyperlink() function as I read from <a href="https://stackoverflow.com/questions/48126574/how-to-insert-hyperlink-to-a-cell-in-google-sheet-using-formula/51855900#51855900">this question</a>, I've been able to link to another tab within the same sheet by hardcoding the hyperlink formula. But how can you incorporate this within a QUERY?</p>
  
  <p><strong>Tab 2: (my attempt but errors out)</strong></p>
  
  <pre><code>=QUERY(Sheet1!A:A,"SELECT hyperlink("#gid=123456789range=A2", A2)")
  </code></pre>
  
  <p><strong>Desired Output:</strong></p>
  
  <pre><code>**Name**
  Chandler [hyperlinked to cell A2]
  Ross [hyperlinked to cell A3]
  Joey [hyperlinked to cell A4]
  </code></pre>