title: Excel - Creating Multiple Lists with a Hyperlink
body: <p>I have three lists - Devices, Device1, Device2.</p>
  
  <pre><code>Devices - Device1 and Device2
  Device1 - 1/1, 1/2, 1/3, 1/4, 1/5
  Device2 - 2/1, 2/2, 2/3, 2/4, 2/5
  </code></pre>
  
  <p>I have the dropdowns working using data validation.  When the device is selected in the first dropdown, the second dropdown gives you the correct list of numbers.  Beside the second dropdown I want a hyperlink that takes you to a separate sheet for the selected device and the cell for the selected number in the list.</p>
  
  <p>Example:</p>
  
  <pre><code>Dropdown 1 - Device2
  Dropdown 2 - 2/4
  Hyperlink - should take you to sheet "Device2" and the cell with "2/4" in it.
  </code></pre>
  
  <p>Can this be done in Excel?</p>