How to i sort and match emails from one column to another ?

hi so i have was cleaning my email list and using app and onlnie service, however i have this problem now :

i have the name and emails column from the web service and another column from the apps :

[img ]https://prnt.sc/knvezj[/img]



i want to make the red column match the emails in the blue column ! like sorting i guess so that i have the name and email to use !