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.