Compare 2 lists and print the value next to it

Hey guys

So I have 2 big lists with Email adresses. 1 of them is in B and the other one is in N.
Next to the list in N, so In O most mail addresses have a value next to them. For instance a company name.

Now I want to compare list B and N with eachother. If a mail adress like 123.. Is in both lists and the N value is X I now want to display that N value in colum C next to the correct mail adress.
Example:

B C O N
123.. q..
a.. p.. LES
b.. 123.. SOC
f.. m.. AP

Only 123.. Is in both lists. Now I want "SOC" to display in C next to 123.. Like this:

B C O N
123.. SOC q..
a.. / p.. LES
b.. / 123.. SOC
f.. / m.. AP

Please let me know if this is unclear but I really need this quickly.

Kind regards
Daan

Apperantly this site doesnt allow me to add multiple spaces thats why my example looks so bad.
there should be 5 spaces between everything