title: How to have VLOOKUP pull multiple instances?
body: <p>I currently have a sheet where I'm organizing launches.
  <a href="https://docs.google.com/spreadsheets/d/1j2IsO0SM1JLJgd-omZ7qspv5MyFRYOqlJacT952RZSs/edit?usp=sharing" rel="nofollow noreferrer">SAMPLE</a></p>
  <p>Currently I have a overview sheet and a calendar sheet which pulls from the overview sheet according to date and event type.</p>
  <pre><code>=iferror(VLOOKUP(B$3&amp;&quot; &quot;&amp;$A4,Sheet1!$A:$D,4,0),&quot;&quot;)
  </code></pre>
  <p>However, when there are multiple &quot;TITLE EVENTS&quot; on a single day, I have to create separate rows w/ &quot;TITLE EVENTS 2&quot; and &quot;TITLE EVENTS 3&quot; in order for VLOOKUP to differentiate and show all instances of title events on the calendar.</p>
  <p>Is there a way (may be <em>a lot</em> more complicated) where I can just have a single &quot;TITLE EVENTS&quot; selection and have the sheet be able to create a new row under &quot;TITLE EVENTS&quot; on its own? (ideal look on sheet 3).</p>