Index / match Return Multiple Strings between Two Dates

I have a three columns for 2018 Holidays :

Subject	Start Date	End Date
Weight Loss Awareness Month	1/1/2018	1/31/2018
National Blood Donor Month	1/1/2018	1/31/2018
National Hobby Month	1/1/2018	1/31/2018
Golden Globes	1/7/2018	1/7/2018
Girl Scout Cookie Season Begins	1/1/2018	1/31/2018
Diet Resolution Week	1/1/2018	1/7/2018
Hunt For Happiness	1/4/2018	1/20/2018
New Year's Day	1/1/2018	1/1/2018
Trivia Day	1/4/2018	1/4/2018

I'm trying to use the following formula to return a list of "active" Holidays between two dates.

=IFERROR(INDEX(Holidays,MATCH(1,(start_dates>=T$5)*(end_dates<=X$5),0)),"")

The start date in this example would be 12/27/2017 and the end date would be 1/3/2018.

Appreciate your consideration.

Regular INDEX/MATCH will only ever return the 1st match it finds, then stop looking.

You will need to use something like the ARRAY formula INDEX(SMALL(IF))) for this

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Try this array formula:

=IFERROR(INDEX(A:A,SMALL(IF($B$2:$B$10<=$F$2,IF($C$2:$C$10>=$F$1,ROW($B$2:$B$10))),ROWS(H$2:H2))),"")

Array Formulae are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.

You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...