extract the next future date with criteria from other column

hi all

i have a table of names (A1:A10) and dates (B1:B10). names can and do repeat. i need a formula that will help me extract the fitting date for a specific name that occurs in the future. i need this to establish for each name when is the next payment due.

example:

name date
joe 1-8-11
jack 20-6-11
jack 5-7-11
ben 15-5-11
joe 13-4-10
ben 20-9-10
jack 1-1-2010

so i want to make a formula that refers to another cell where i just put the name of the client and it gives me the next available date of payment (today is 1-7-11 so for jack it would answer 5-7-11 for Joe it would answer 1-8-11 and for Ben it would say that there is no future payment)

the "=MIN(IF" option is good for giving me the earliest date number but not in the future.

please help...i am stuck with a big project.

a huge thanks in advance

Hi, here is a possible solution (if I have understood correctly what you are trying to do).
This can without doubt be done with a more efficient code, but this is what I have come up with.

The formula in E4 must be entered with ctrl/shift/enter.

I forgot to include message whwn there is no future date (see new attachment)

I am throwing all my comic books!!! you are my new hero!!!!!!!!!!!!

Aim to please:-D