Can't find formula giving last match of three criteria

As shown on attached. Col A has User Names. Col B shows dates various mailers were sent to them. If Col C is Zero, they never opened the mailer.

I have the formula showing the date the latest Mailer was sent to each person (=LOOKUP(2,1/($A$1:$A$16=$G2),$B$1:$B$16)

What I need is the third criteria - What was the date of the last mail they actually opened? (i.e. Find the last date in Col B where the name matches Col A and Col C is not Zero)

J15 - 20 shows what the result should be.

All suggestions, pointers and guidance welcome as ever.

Ochimus

Jason,

Both prompt solutions much appreciated. Odd that I've never had this question before in all the time I've used Excel!

Still not sure where the formulae determine that Col C has to be blank?

Now posting this as "Solved"

Ochimus