title: Excel Formula to look up a value in another table, but bring through ALL results
body: <p>I have set up data consolidation so the user can select from a list of dates. When the user changes the date, I want a formula (preferably a formula rather than VBA), if one exists, to look up the date in the table contained on the next page and bring through information based on this data.</p>
  
  <p>I know that vlookups can look up on the table obviously with something like this:</p>
  
  <pre><code>=VLOOKUP(dateCell, table, colIndex, False) 
  </code></pre>
  
  <p>But this seems to only bring through the first result- is there any way I can set this up so that after the first result has been brought through, I can bring through the second, third, fourth, etc. There will be multiple occurrences of each date so there will be multiple values that I want to bring through- one on each row.</p>