title: Create a list from Table
body: <p>I managed to enter data to a database via a form;
  actually works like a charm.</p>
  
  <p>Now, what I need, is a lookup function (preferably not a form), with which I can search a table on another worksheet.</p>
  
  <p>Let's say, I have an edit field or a cell, in which I enter a term which shall be looked for in a certain column on the table in another worksheet.
  I would like to get a list of all entries which contain the word and the value from another cell (an ID).</p>
  
  <p>Example:</p>
  
  <p>Search term: Tom</p>
  
  <p>Table: </p>
  
  <pre><code>Tim | 2
  Tom | 3
  Tommy | 5
  </code></pre>
  
  <p>The List should Show Tom and Tommy and their respective IDs,
  but everything I tried didn't turn out as intended (mostly didn't work at all)...</p>