Lookup last value using 2 criteria

[Busymanjohn]

Hi Guys, I am having problems with a formula, I am trying to lookup a range of cells and return the last value in that range based on 2 criteria ,,, I can return the last value based on 1 criteria using LOOKUP(2,1/(B3:B16=F6),C3:C16), but how do I insert the 2nd criteria ,,,, also looked at Index & Match, doesn't quite get me the result ( although I could be missing something ). Sample file attached ..... the results I want to appear in cells G6 and G7 ,,, range is in A3:C16, criteria is F2 and F6 ( time range and date ). Any ideas?

 

[Hui]

G6: =INDEX($C$4:$C$16,SUMPRODUCT(--MAX(($A$4:$A$16=$F$2)*($B$4:$B$16=F6)*(ROW($A$4:$A$16)-3))))
copy down

 

[bosco_yip]

In G6, copy down :

=LOOKUP(2,1/((A$4:A$16=F$2)*(B$4:B$16=F6)),C$4:C$16)

Regards

 

[Busymanjohn]

Thanks guys, both solutions worked a treat .....