Using Index for Multiple Returns from an array

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 !!

TRY

=IFERROR(INDEX($H$2:$H$27,SMALL(IF($G$2:$G$27=$G$34,ROW($G$2:$G$27)-row($G$2)+1,""),rows($g$2:g2))),"")

=IFERROR(INDEX($I$2:$I$27,SMALL(IF($G$2:$G$27=$G$34,ROW($G$2:$G$27)-row($G$2)+1,""),rows($g$2:g2))),"")

Enter both with Ctrl+Shift+Enter

copy down

JohnTopley,

Excellent, that worked, but now I'm moving the results to a different location on the sheet, and it stops working...

I've moved the Month in G34 to B34, amended the formula where it says $g$34 to $b$34, and it imediately stops working. Clearly I'm missing something from the mechanics of this ?

Doh. Wasn't using the ctrl, shift and enter command to run array formula. Now to get it working from another sheet....