VLOOKUP problem

[djh30]

So I have two spreadsheets with different information that needs to be combined. On one sheet is a list of names (about 600) and corresponding emails that are associated with these names. On the other sheet there is a similar list of names (but not exactly the same) with different info associated with them. I need to find all the names that appear on both sheets and pull the emails from the first sheet, and add them to the second sheet. Is there a practical way to do this? I played with VLOOKUP possibilities, but it doesn't seem to efficient.

[Special-K]

What does "corresponding emails that are associated with these names" mean?
A single cell with an text content that represents an email?
Or several cells?

From your brief information we can't determine how the data is laid out so it's prob best to post a spreadsheet.

[mikeTRON]

I would always recommend posting a sample dataset that has been cleaned off personal information.

Vlookups can only help you find an EXACT match, is that what you are looking for?