Need help matching up two lists of email addresses

Hello everyone, this is my first time on here so please forgive me if I'm breaching any etiquette.

I need some help with a problem I'm having at work - here's the situation. I'm starting up my own business and need to add my e-shot signup list to my new CRM - don't worry, my list has been fully cleaned and validated!

I have two lists of email addresses - one with 37,000 records on it (List A) and the other with 7,000 or so (List B).

Most of the email addresses in List B are also contained in List A (but not all). All of the records in List B also have contact numbers. All of the records in List A have a lot more segmentation information that is very useful to me.

I would like to cross-reference the two lists, so that the contact numbers from the duplicate records in List B are transferred to the corresponding records in List A, meaning that the records in List A keep the segmentation information but also have the contact numbers. I would then like the duplicate records from List B removed entirely.

I would also like the non-duplicate records in List B to be transferred to List A as brand new records.

I understand how to use conditional formatting to highlight duplicates but I just don't have the time to go through 7,000 highlighted records manually, copying the contact number over then removing the record. I also know how to remove duplicates using excel, but I really need the contact numbers to be transferred across before I do this.

I don't really understand macros or VBA (sorry) but I'm happy to use if, countif, and other formulae/functions, so please don't quote me loads of lines of code as I'm sure I'll mess it up!

I hope that this makes sense - I've spent the last two weeks getting the data to this stage and it feels like I've hit a brick wall!

Hope that you can help, Dan.

Hi Amotto, thanks for responding. Each piece of data has its own separate column - first name, surname, company, position, email address, contact number, skill 1, skill 2 etc. List A contains everything except the contact number, List B contains most of the information but not the Skills. It's taken a lot of effort to segment the skills so I need to keep that information but I'd like the contact number form List B transferred to the appropriate record in List A.

The easiest way I can think of is to create two columns at the end of List A and paste in the email address and contact number from List B, then find a way to make them correspond correctly with the email addresses already in the spreadsheet. For the sake of keeping things simple, let's say that my List A email addresses are in column A and the records from List B are pasted into columns Y and Z. Of course, I could be wrong as to whether that's the correct approach.

Does that make sense? I hope so!