title: Excell problem. use drop down box to select a header from another table. then display the entire columns info
body: <p>this is my table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>1</th>
  <th>2</th>
  <th>3</th>
  <th>4</th>
  <th>etc</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>fish</td>
  <td>card</td>
  <td>green</td>
  <td>bike</td>
  <td></td>
  </tr>
  <tr>
  <td>dog</td>
  <td>paper</td>
  <td>blue</td>
  <td>car</td>
  <td></td>
  </tr>
  <tr>
  <td>cat</td>
  <td>rock</td>
  <td>red</td>
  <td>lorry</td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>i have a drop down with 1,2,3,4</p>
  <p>i then want to display</p>
  <p>fish
  dog
  cat</p>
  <p>when i select 1 in the dropdown in cells a13-a15 for example.</p>
  <p>if i use this in A10</p>
  <p>='REF DET'!A2:A8</p>
  <p>(the table im looking in is on another sheet called REF DET)</p>
  <p>i get the result i want but obviously it doesnt change when  i change the drop down.</p>
  <p>Hope this makes sense.</p>
  <p>Thanks in advance</p>