Selecting an Email Address based on Latest Bounce Date

**brownna** · 04-26-2013, 03:16 AM

Hi ,

I am hoping someone will be able to help me with a formula I am trying to write. I am wanting to take the latest date that an Email Address has bounced I am writing the formula using a count indicator to determine how many times the email address is present and then am using this formula =IF((VLOOKUP(A2,A:B,2,FALSE)=B2),B2,"OLD") but I am only seeing this work when I do not have an Email Address that has bounced >1 as it seems to then invert the query and tells me that the most recent date is actually the OLD or FALSE date rather then passing back the Lasted Bounce in filed B2.

Attached is a Sample worksheet.

I would like to know if I should be editing my formula in a different way or should be using an entirely different formula.

Cheers,
Nathan

**Lemice** · 04-26-2013, 05:29 AM

Hello,

You can try this Array formula

Please Login or Register  to view this content.

You will have to hold Ctrl-Shift and hit Enter to enter the formula, because it's an Array formula (If you do it right, you will see the formula being wrapped inside a { } )

For your question why your formula does not work, VLOOKUP always return the first value it found (So if you have duplicated data, it can only return the first one).

Here is your sample file with the formula, with 1 less column.