index match all/nth within date range

[H2G2]

Self-taught Excel user, First-time post: I am trying to use index match to return product serial numbers ($AH$2:$AH$157) based on inspection due dates ($AK$2:$AK$157) (i.e., all products due in 2024). Date array is in dd/mm/yyyy format, with some zeros. Have done SUMPRODUCT for the year 2024 with return of 7, need to know which 7 products are due without sorting as the sheet is source to others.

 

[H2G2]

I have the following that returns the 1st match:
{=INDEX($AE$2:$AE$157,MATCH(1,(($AK$2:$AK$157<=$AQ$161)*($AK$2:$AK$157>=$AQ$160)),0))} where $AQ$160/$AQ$161 refers to dates 1/1/2024 & 12/31/2024 respectively.

 

[Fluff]

How about

=IFERROR(INDEX($AE:$AE,AGGREGATE(15,6,ROW($AE$2:$AE$157)/(($AK$2:$AK$157<=$AQ$161)*($AK$2:$AK$157>=$AQ$160)),ROWS(A$2:A2))),"")

 

[H2G2]

How about

=IFERROR(INDEX($AE:$AE,AGGREGATE(15,6,ROW($AE$2:$AE$157)/(($AK$2:$AK$157<=$AQ$161)*($AK$2:$AK$157>=$AQ$160)),ROWS(A$2:A2))),"")

That did it! Thanks. Working in MS 2010 -vs- 365 is a challenge (reverse engineering formulas).

 

[Fluff]

You're welcome & thanks for the feedback.