Trying to summarize from a worksheet to another (summary worksheet). The VLOOKUP should give an "X" if includes "August" and instead gives the same answer for every search since there are multiple of the original search; it's saying yes since it saw it the first time, but shouldn't if actually missing.
Original worksheet sample and summary worksheet with formula below. Thank you in advance for your time and assistance.


