Filter By Intersecting Columns

So here's my issue with excel... I'm guessing this is possible to solve, but I have no idea how to do it so I'm asking for your help.
I've got a table in excel on one Sheet with 2 columns: Name and Email Address.
Now on another Sheet I've got a table with only one column Email, in which I've got the same emails minus the invalid ones.
What I want to do is to have in the first table on the first Sheet only the valid email while keeping the name as well.
I imagine that to be a filter that would use table in the second sheet as a filtering rule and display only the valid email addresses.

I don't know much about macros and excel programing but I think this might be possible and I have no idea where to start.

Can someone help me with this?
You can find the file I was talking about attached.

Thanks in advanced,
Cristian

Originally Posted by shg

Welcome to the forum.

In C2 and down, =ISNUMBER(MATCH(B2, 'Valid emails'!A2:A41, 0))

Filter on that.

Thanks for the quick reply... but the formular doesn't work like it should... it would be perfect if only the B2 variable would change because like it is now for example on C3 i get:
=ISNUMBER(MATCH(B3, 'Valid emails'!A3:A42, 0))
on C4:
=ISNUMBER(MATCH(B4, 'Valid emails'!A4:A43, 0))
and so on...
the search should always be between the A2 and A41 or the idea is for the formula to compare each element from the B2 column with each element on A2 column on the 'Valid emails' sheet.

Any idea on how to fix that?

thanks my friend... you're a life saver! works perfectly!