title: Lookup multiple rows for a single term
body: <p>I have a spreadsheet table that looks like this:</p>
  
  <p><strong>Table: Group Info</strong></p>
  
  <pre><code>Group ID    Location    Leader 1 Leader 2 Leader 3
  --------------------------------------------------
  Antelope    C7          Anne     Brenda   Carol
  Billygoat   C8          Derek    Edgar    -
  Cantaloupe  B3          Georgie  Hilda    -
  ...
  </code></pre>
  
  <p>The Group Info table lists information about each group according to the Group ID.</p>
  
  <p>And in another table:</p>
  
  <p><strong>Table: Leader Info</strong></p>
  
  <pre><code>Group ID    Leader      Email
  --------------------------------------------------
  Antelope    Anne        anne12@example.com
  Antelope    Brenda      brenda@example.com
  Antelope    Carol       carol.s@example.com
  Billygoat   Derek       derek@example.com
  ...
  </code></pre>
  
  <p>The Leader Info table lists information about the leaders, including which Group ID they belong to.</p>
  
  <p>What I'd lke to do is to be able to use the second table (Leader Info) to populate the first (Group Info) in the "Leader 1", "Leader 2", "Leader 3" columns. I know that each <code>Group ID</code> wil have at most 3 leaders, but possibly less.</p>
  
  <p>Is there a way to look up the "Leader 1", "Leader 2", "Leader 3" columns from the Leader Info table?</p>