title: Google Spreadsheet: Dynamic Hyperlink Formula
body: <p>I'm trying to create a dynamic HYPERLINK formula that will automatically create the link based on the sheet name in Column A, but I'm not sure how (or if it's possible) to get the URL of the sheet based on the name.</p>
  
  <p>Here's the setup:</p>
  
  <ul>
  <li>Single Google Spreadsheet with multiple tabs</li>
  <li>Tab names: 1500, 1501, 1502, Consolidated</li>
  </ul>
  
  <p>On the Consolidated tab, I have two columns: Column A is the Sheet Name, and Column B is a HYPERLINK formula, that when clicked should open the corresponding sheet.</p>
  
  <p>Is there a way to programmatically get the URL for the sheet based on the sheet name in Column A? Perhaps I could use a script to populate Column C with the URL, then use the following formula: =HYPERLINK(C2,A2)?</p>
  
  <p>Thanks for the help!</p>