Hi. I can work on this for you immediately, but will take a different approach than directly in Excel. I will import both lists into access and do a couple queries and then export the relevant data back to excel. I will also send you my access DB if you require.
When you Hire me, you'll be hiring a professional with 10+ years in the IT industry and two Microsoft Certificates. Please see my feedback/profile right here on Freelancer, a testimony to my excellent work and professional approach. All customers are 100% satisfied.
Looking forward to helping you on this, and building a working relationship toward the future. Kind Regards, Kenny. P.S. I'm from the Caribbean so there's no language barrier and our time zones should be close as well.