Search code examples
arraysgoogle-sheetsfiltergoogle-sheets-formulagoogle-query-language

In Google Sheets, is there a MATCH or INDEX formula that will show multiple matching cells? [example provided]


I have a formula that matches and indexes from a sheet called Events and it going into a sheet called readyishJuly. The problem is that if I have 2 events with the same date, it will only show 1 of them. I'm not sure how to trigger an array search (making up that term cuz it sounds similar to what I'm thinking about). Below a workable sheet made for y'all to pick at. Thanks in advance. I would be more specific if I understood what I was asking for better.

https://docs.google.com/spreadsheets/d/1F46br9YQ29guHGZS_VCGGT0T8X6mlbdKjMH-zdygQXE/edit?usp=sharing

Events being called from Events sheet

Where I would like it to show up in readyishJuly sheet


Solution

  • try:

    =FILTER(Events!B6:B, Events!J6:J=G10)
    

    enter image description here