Match and Assign

[Blessy Clara]

Hi,

I have an excel sheet with two columns

Col 1 - Named Bounced - contains - All bounced emails
Col 2 - Named Data - Contains Complete Email data

Requirement - I would like to assign "Y" in Col C if the email in Data matches with Email in Bounced. This is to separate the bounced emails from the other emails

Example as [TABLE="width: 500"]
<tbody>[TR]
[TD]Bounced (Col A)[/TD]
[TD]Data (Col B)[/TD]
[TD]Col C[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]zum@zumbakery.com.au[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]canio.monaco@alternativeplastics.net.au[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]info@electricky.com.au[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]canvas.works@bigpond.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]george@pacifickustomz.com.au[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]zum@zumbakery.com.au[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]canio.monaco@alternativeplastics.net.au[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]capalaba@chemistwarehouse.com.au[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Y = The emails in Datalist are found in Bounced Col, Hence assign Y

There are more than 463852+ Emails in Col Data

Thank you in Advance

 

[mole999]

Not quite what you are asking for, this returns the matches and shows #N/A (i.e. your Y)
=VLOOKUP(A1,$B$1:$B$463852,1,0) put in C1 and drag down

 

[Blessy Clara]

Not quite what you are asking for, this returns the matches and shows #N/A (i.e. your Y)
=VLOOKUP(A1,$B$1:$B$463852,1,0) put in C1 and drag down

Hi Thank you for your response
"
Actually I am trying to categorize Bounced Emails from my main Database. Bounced Emails are found in Col A, and My main Email list is found in Col B. So For example, there is an email info@abz.com in main Datalist, if this email is also found/matched in the bounced list then it must be assigned Y

So this way i can separate all bounced emails from my main list