EXCEL to find the same values and delete the

There are two assumptions worksheet.Each has a worksheet, which is to filter out the different data how can one find the same data and the two are removed?

in Table 1 of the cell B1 enter = VLOOKUP (A1, Sheet2! A:A, 1, FALSE), to copy down
in Table 2 of the cell B1 Input == VLOOKUP (A1, Sheet1! A:A, 1, FALSE), and then down
copy of Table 1 column B of Table 2 for a copy – Paste Special –
value for the last 2 table B carried out in addition to the deletion of the value of screening for # N / A Other firms use VLOOKUP function