Adding another If Statement to an array formula

I am very new with array formulas and can normally work my way through adding additional criteria to regular formulas but this one is giving me trouble...

This is my current formula that works as is:
=IFERROR(INDEX(EVENTS!$B$9:$F$293,SMALL(IF(Dates=O$6,ROW(Dates)),ROW(2:2))-TableRowStart,3),"")

I would REALLY like to be able to tell it to only bring back the items that are visible from the table. With that in mind, I have added a column in my table labeled "Visible" and have it bringing back a value of 1 if the row is visible and a 0 if it is hidden. Is there any easy answer as to how to properly nest this in?

I appreciate all help!

Hmm. That didn't make the data show up. Why do you use the *?

The "*" is the "AND" condition. An OR condition uses "+".

Post a small file (not image) if you are still having problems.

To upload a file click "Go Advanced" then scroll down to "Manage Attachments"

I believe I Have attached the document.

I have a list of data on "events" tab. They cover different months.

When I select the slicer for any one of those months and then go to the "calendar" tab, I only want the Visible cells from the events tab to show up on the calendar. So, on the attached I have December open. If I chose the slicer for Dec, then on November 30th (visible on December calendar) it should not show up the "Onsite Interim Testing".

I have two cells on the calendar that are a different color, which are the ones I was changing the formula on to test. One is on November 30, one is on December 1. The rest of the dates on the calendar have not been adjusted at all and show everything that is listed (visible or not) on the Events tab.

Thank you!

Define "Visible" as Named range.

Perfect! I wondered if that was an issue when it didn't show up as auto-populated, but wasn't sure how to fix it. THANK YOU!