Struggling to Use Small(IF...)) formula to return multiple results

[trhyh]

Hello,

This is my first post here, I'm a little unsure of how I should best ask this question.

I'm trying to use a Small(IF(...)) Formula to return results. Currently I have a set of data in which there is a column indicating the date that it's due, given in (d/m/y) format. In a separate sheet I have a cell in which I populate the current date that the report is generated, ex) today is 8/15/2019(C1), and a few cells over I have the formula =month(C1) which gives me "8".

My formula I'm currently using to display the rows in which the month is "8" is give by:

{=SMALL(IF(MONTH('Alberta Planning Sheet Falcon'!$D$1:$D$29='In Month FSAs'!$F$1),ROW('Alberta Planning Sheet Falcon'!$D$1:$D$29)),ROW(1:1))},

I'd eventually like to wrap an index match and iferror formula around this formula to show the data I'd like to present, however I'm struggling to get any output and receiving an error.

I suspect that it might be due to data types? Where the MONTH(...) may be generating some sort of data type dissimilar to the value I'm trying to equate it to.

Please let me know if I can provide any more information, thank you for any assistance.

 

[trhyh]

Hey Fluff,

Apologies to bother you again haha. I didn't realize that after I got the formula to output data, I didn't realize it was showing incorrect data. For some reason, I wanted the months to display "August" as the current month is August, for some reason my data is showing November dates.

Here is the finalized formula:
{=IFERROR(INDEX('Alberta Planning Sheet Falcon'!$A$2:$K$29,SMALL(IF(MONTH('Alberta Planning Sheet Falcon'!$D$2:$D$29)='In Month FSAs'!$F$1,ROW('Alberta Planning Sheet Falcon'!$D$2:$D$29)),ROW(1:1)),1)," ")}

where $F$1 = MONTH(C1),

where C1 =TODAY().

 

[Fluff]

Without being able to see your data, it's difficult to tell, but try this non array formula

=IFERROR(INDEX('Alberta Planning Sheet Falcon'!$A$2:$A$29,AGGREGATE(15,6,(ROW('Alberta Planning Sheet Falcon'!$A$2:$A$29)-ROW('Alberta Planning Sheet Falcon'!$A$2)+1)/(MONTH('Alberta Planning Sheet Falcon'!$D$2:$D$29)=$F$1),ROWS($A$1:$A1))),"")