Array formula which will search the from date but not the end date

[bagguley]

Evening All,

Would anyone be able to help with my current problem. I am building a spreadsheet which manages PPE issues (all very exciting!). I am currently attempting to find the correct array formula to search records from table [Issues] between two dates - start=H2, End=M2 and display in a new table on a different sheet.

The first formula works fine, displaying everything after the date in H2, the second will not.

=IFERROR(INDEX(Issues[REF], SMALL(IF(Issues[Date]>=$H$2, ROW(Issues[REF])-MIN(ROW(Issues))+1), ROW(A1)), COLUMN(A1)),"")

=IFERROR(INDEX(Issues[Quantity of Coveralls], SMALL(IF(AND(Issues[Date]>=$H$2,Issues[Date]<=$M$2), ROW(Issues[Quantity of Coveralls])-MIN(ROW(Issues[Quantity of Coveralls]))+1), ROW(A1)), COLUMN(A1)),"")


If anyone could tell me where Im going wrong it would be greatly appreciated.

[Tony Valko]

You're going wrong with the AND() function.

Here is that expression in pseudo code:

SMALL(IF(range>=$H$2,IF(range<=$M$2,ROW(range)-MIN(ROW(range))+1)),...