Lookup up multiple variables

I thought i has this solved but i now need to not only pick up a date in the table but any txt that is is there too. again i've attached an example.

i've found the formlula =SUMPRODUCT(--($B$2:$B$13=G2),--($C$2:$C$13=H2),$D$2:$D$13) works fantastic but it onl;y picks up dates.. is there anyway i can get this to pick up txt adn dates in the same way?


Hi is there any way to do a mulitple look up within a v look up? I've attached an example of what i'm trying to do. i want to be able to look at the ref and the prod in table one (col Band C) and if they match he ref and prod in table 2 (cols G and H populate the date from table one that applied to them in column J i realise this involves 4 citeria in a look up and i dont know how to do that? any ideas?

If the combination of entries are unique, then try:

=SUMPRODUCT(--($B$2:$B$13=G2),--($C$2:$C$13=H2),$D$2:$D$13)

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)