array formula

Maybe a simpler approach with the ROW() idea you suggested and a key that makes the need for an array unnecessary. Have a look.

Both of these formulas are great. Morrigan was able to add it one step farther and allow for a 2nd filter which I love however I cannot for the life of me figure out how to add more items onto the table...

Does anyone whow if there is there a function that allows the results to "push to as many rows as needed without being in each row?

The new value is

=INDEX('Results Key'!$D$1:$D$7,SUMPRODUCT(SMALL(--('Results Key'!$B$1:$B$7<='Data Information'!$B$4)*IF('Data Information'!$B$5="",1,--('Results Key'!$C$1:$C$7='Data Information'!$B$5))*$A$3:$A$3,SUMPRODUCT(--('Results Key'!$B$1:$B$7<='Data Information'!$B$4)*IF('Data Information'!$B$5="",1,--('Results Key'!$C$1:$C$7='Data Information'!$B$5))-1)*-1+A3)))