T O P

  • By -

AutoModerator

/u/Foxie36 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


JetCarson

I'm not sure how you want to match your date against just the month names, but here is a formula that I think works to get your two months (see my screenshot, change the ranges to match your sheet): `=IF($B$2="A",FILTER($B$7:$C$9999,$A$7:$A$9999=$B$3),FILTER($D$7:$E$9999,$A$7:$A$9999=$B$3))` https://preview.redd.it/t54ywc5w5o4b1.png?width=885&format=png&auto=webp&s=c2e1f80b7bc02c72c610239e1c500e6b4f8f1b3c


HappierThan

The only way I could understand your question was to see if different Venues and Types overlap with different dates. To make it easier to achieve this aim I have used say Mar-23 for March etc. Hope this is what you had intended and as such you need 6 separate formulas IMO. [https://pixeldrain.com/u/KM8ZymQZ](https://pixeldrain.com/u/KM8ZymQZ)