Excel Formula Based on 2 Criteria

[ststern45]

I have the following formula for just 1 criteria but I was trying to figure out how to do this with 2 criteria

=INDEX($AL20:$AL1019,AGGREGATE(15,6,(ROW($AL20:$AL1019)-ROW($AL20)+1)/($BT20:$BT$1019=7),1))
The above formula indexes the row $AL20:$AL$1019 that contain the row numbers 20 through 1019
$BT20:$BT$1019 contain values 6, 7, 8, 9, 10, 11, 12
The 1 at the end of the formula finds the row number for the 1st occurrence of the value 7 from cell range $BT$20:$BT$1019

Is it possible to add to the formula that will calculate a 2nd criteria from cell range $BV$20:$BV$1019 that contain the value 3

Thank you in advance!!

 

[DanteAmor]

How about:

=INDEX($AL20:$AL1019,AGGREGATE(15,6,(ROW($AL20:$AL1019)-ROW($AL20)+1)/(($BT20:$BT$1019=7)*($BV20:$BV$1019=3)),1))

 

[ststern45]

Awesome!!
Works like a charm.
Thank you so much
Steve