Vlookup Email Data. Need Help Please! :)

Hi there,

So I am doing some email outreach which contains multiple columns in excel (business name, website, email address, phone etc.)

I took the spreadsheet and cleaned the email addresses so I could just get verified emails.

The software I used to clean the emails spits out just the email column... so now the emails don't match up to the corresponding business name, website, phone number etc.

My question is how do I use the clean email to find the corresponding other business attributes and line them up correctly?

I think I use the Vlookup or Search function to find the Clean email in the Old email column that will match up with the corresponding business name, phone number etc.

I've been working on this for hours to no avail.

Spreadsheet is attached. Clean Emails are in Column A and the Old emails are in Column B. All the attributes line up to column B.

Any advice would be greatly appreciated!

Nathan

.
Will it make a difference to your email cleaning software, if you sort your data first in alphabetical order ?

.

I am certain there are many ways to accomplish this goal. Here is one ...

After reviewing your data, these two macros will achieve the goal. Macro compare_cols will review Cols A & B and color red those cells in Col B that do not match Col A.

MyHideMacro will hide all of the red colored rows, leaving only the matching email rows you are seeking. The macro CpyPsteSht1 will copy the visible rows and paste them onto Sheet1 (you'll need to add another sheet named
Sheet1).

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you so much! I will try this and see let you know
if I have more questions.

Nathan