Hi everyone, first post !!

I've got an excel sheet that consists of an array of national holidays. They are sorted by month with the first column being the month name, second column description of the event, and third is the exact date.

What I'd like to do is to pull all of the values from January, returning both the description and exact date.

=IF(ISERROR(INDEX($G$2:$G$27,SMALL(IF($G$2:$G$27=$G$34,ROW($G$1:$G$27)),ROW(1:1)),2)),"",INDEX($G$27:$H$27,SMALL(IF($G$2:$G$27=$G$34,ROW($G$2:$G$27)),ROW(1:1)),2))

Is the formula I'm using.

Array is G2 : G27

G34 holds the month I'm looking for

Column G is the Month,
Column H is Description
Column I is the Exact Date

I will take it if I can even just get the description returned.

I know how to use ctrl shift & enter for an array formula, and that I need to paste this down for how many rows to show each entry, but I'm totally lost here !!