Hi, i'm new at this forum, and i have difficulties with a formula in my worksheet.

I have a excel sheet with 3 rows.

In row A i have about 1000 customer numbers.
In row B i have their email adresses.
In row C i have about 500 of the 1000 customers.

I want to match the customers in row C with the customers in row A, and then extract their email adresses.

Or if you see it in another way, i want to remove the customers in row A that does not match the customers in row C. I would then see which 500 customers that are left, and i would have their email adresses displayed in row b.

The whole clue with my question is that i want to find out the email adresses of the 500 customers in row C.

If anyone can help me with this, i am very grateful.