Array Formula to Match on 3 Variables

Hello,

I have an array that I am trying to use. I want it to match based on three values. The first (listed in the formula as $B$9) is a name, the second is a start date ($H$9) and the third is an end date ($N$9).

Please Login or Register  to view this content.

I added the And() function to try to add the additional variables to the small() array, but it didn't work.
It works perfect when I don't use the start dates and end dates, but I get more data then I want... I just want a picture of the data during a time frame. The Dates are stored in column DA on the database worksheet.

Awesome, I love it when solutions are this simple.

as a second part, if i need it to match one of the variables against two columns, how would i use an "or" function in the array?