Please help! I had a list of emails that were attached to a specific code (email in worksheet 1, column A and codes in columns F and G). In worksheet 2, I have another list which had merged a few lists together including the emails that were in worksheet 1, column a, but the codes never made it to the list on worksheet 2. I'd like to either search both lists, and when there is a match, attach the codes from worksheet 1 and bring them to worksheet 2. Or use worksheet 1 and highlight the matches from worksheet 2 so that I already have the codes from worksheet 1 there. I guess, I could then delete the cells that were not matches and bring the codes manually to worksheet 2 that way, though that seems more complicated.

I should mention, the list of emails in worksheet 2 is a combination of 4 lists that I merged and deleted duplicates. The emails that I used from the list on worksheet 1 is highlighted in blue so I know which emails are from the list on worksheet 1. Only problem, is there were dupes, so some emails won't match since there are emails from different lists on worksheet 2 and the emails that I copied over from my list in worksheet 1, had duplicates, so I deleted those. Now I just need the remaining emails that I copied from worksheet 1 to worksheet 2, i need to transfer the codes that go with those specific emails.

The file is mega big, so I've been working in Libre Office. And I've been trying to use Vlookup but i keep getting a error message. Please help! I need this asap.

xValerie