Thread: multiple criteria between two values, multiple solutions

I would like to find a formula that combines two formulas that I am working with. I would like to input two criteria (cells G4 and H4) that is equal to or in between the values in columns B-C & D-E respectively. I would like all posibilities in column F to populate in the cells to the right of the search criteria. I have a formula that populates the cells if the criteria is exactly what is in columns B and D (I3:N3). And I have a formula that finds the first result equal to or in between the min and max columns (I4). But I want to combine the two formulas.

I hope this makes sense. Thanks for your help!

INDEX($F:$F,SMALL(IF(($G3>=$B$3:$B$19)*($G3<=$C$3:$C$19)*($H3>=$D$3:$D$19)*($H3<=$E$3:$E$19),ROW($F$ 3:$F$19),""),COLUMN(I3)-COLUMN($I3)+1)) array entered in I3 then filled across and down perhaps.

Beau Nydal

It worked!!! Thank you so much!