Lookup up multiple variables

So you want the firs occurrance? The last occurance?

First occurance:

=INDEX($D$2:$D$13,MATCH(1,INDEX(($B$2:$B$13=G2)*($C$2:$C$13=H2),0),0))

Last occurance:

=LOOKUP(2,1/(($B$2:$B$13=G2)*($C$2:$C$13=H2)),$D$2:$D$13)