Vlookup and Sorting

[xlsnut]

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>

 

[Oaktree]

Probably not, since "John Smith" will not match against "Smith, John" or "john.smith@mail.com"

To use VLOOKUP, you'd need to either match your formats in the two lists (so they're both "Last, First" or "First Last" or "first.last@mail.com")

Alternatively, FUZZYVLOOKUP from the board's hall of fame might be of interest: http://www.mrexcel.com/forum/showthread.php?t=69649

 

[pegsnpops]

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>

Why dont you concatenate First name and Last Name with space in between in a new column as Column A, sort it and run vlookup on it. It should help.