Match email

[niladri20052006]

Hi All,

I have a file consisting of four sheets. In all these four sheets one common filed is Email ID.

In another file I have only email ID column. I want to remove the matched email ID form the above four sheets. I am applying vlookup 4 times for the 4 sheets.

Is there any option to do it at one time?

Thanks in advance.