match up the Bounced emails in Column "C" with the email in column "B".

Try this revised play
Assume data in cols A, B, C (as per post) start in row2 down
In D2:
=IF(ISNUMBER(MATCH($C2,$B:$B,0)),INDEX(A:A,MATCH($ C2,$B:$B,0)),"")
Copy D2 to E2, fill down to last row of data in col C. This should return
cols A & B aligned with the bounced email in col C.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AGOLFA" wrote:
Thanx Max for your help, but it isnt working how I intended it to.
I wanted to be able to match up the Bounced emails in Column "C" with the
emails in column "B".
Your formula has marked the bounced emails with an "x" in column "D" and
when sorting hasnt moved them next to the duplicate email in Column "B".
Is there something im doing wrong or is the formula incorrect?
Sorry for the inconvience and thanx for your help in advance.