I have a question not sure if I am using Vlookup correctly but hopefully someone can help.
In sheet 1 I have a list of names listed like this: John Smith
In Sheet 2 I have a list of names that I exported from a mail client that are listed like such: <TABLE style="WIDTH: 328pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=437><COLGROUP><COL style="WIDTH: 328pt; mso-width-source: userset; mso-width-alt: 15981" width=437><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 328pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=437>Smith, John,john.smith@mail.com,"","",06/04/2008,""
Because sheet 2 has like three thousand names and I only need to extract about of 200 of them which are listed in sheet 1, will VLOOKUP help me sort this function to pull only the names and email addresses from sheet 2?
Thanks
C-
</TD></TR></TBODY></TABLE>
In sheet 1 I have a list of names listed like this: John Smith
In Sheet 2 I have a list of names that I exported from a mail client that are listed like such: <TABLE style="WIDTH: 328pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=437><COLGROUP><COL style="WIDTH: 328pt; mso-width-source: userset; mso-width-alt: 15981" width=437><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 328pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=437>Smith, John,john.smith@mail.com,"","",06/04/2008,""
Because sheet 2 has like three thousand names and I only need to extract about of 200 of them which are listed in sheet 1, will VLOOKUP help me sort this function to pull only the names and email addresses from sheet 2?
Thanks
C-
</TD></TR></TBODY></TABLE>