Hi,

Let's see if I can explain my problem and if you can help me !

I have a table such as:

Column A = Partners name
Column B = Date
Column C = Last Entrance Indicator (cell = "" when the partner does not appear later in the table or = "YES" if it appears later)

The date in column B is only showing up for the last entrance of a partner (eg: if partner X appears in row 3, 8 and 10, date will only appear in row 10)

So for instance, my table will look like

Partner 1 ; "" ; YES
Partner 2 ; 12/03/11; ""
Partner 3 ; 25/04/11; ""
Partner 1; 10/06/11; ""

On a separate sheet, I want to return the date for a specific partner.

In this case, I want the date for partner 1.
Using a vlookup doesn't work because the formula stops at the first instance (row 1) and the formula will return a blank.

What formula could I use to say: if the first date cell for this partner is blank, keep looking in the table and return the date? (note: in this example partner 1is only repeated once, but it might be repeated several times)

Thank in advance for the help.